Hi all,
I am currently exploring best practices for utilizing the Internal_Part_Issue_Pub table within the context of Demand Planning. I’ve noticed that the table includes multiple transaction types, and I understand that the appropriate configuration often depends on specific business practices.
That said, is there any recommended or commonly used Source_Ref_Type or Transaction Code for standard Demand Planner base flow configurations?
Any insights or guidance would be greatly appreciated.
There is the where condition used in this view.
SELECT tran.part_no part_no,
tran.contract contract,
tran.date_time_created date_issued,
Decode(tran.direction,'+',tran.quantity * -1,'-',tran.quantity, 0) qty_issued,
Inventory_Transaction_Hist_API.Get_Cost(tran.transaction_id) unit_cost,
Inventory_Location_API.Get_Warehouse(tran.contract, tran.location_no) warehouse_id,
Warehouse_API.Get_Warehouse_Type_Id(tran.contract, Inventory_Location_API.Get_Warehouse(tran.contract, tran.location_no)) warehouse_type_id,
DECODE(Inventory_Location_API.Get_Remote_Warehouse(tran.contract, tran.location_no), NULL, 'FALSE', 'TRUE') remote_warehouse,
tran.source_ref_type source_ref_type,
tran.transaction_code transaction_code
FROM mpccom_transaction_code_pub code,
inventory_transaction_hist_tab tran
WHERE code.inventory_stat_direction_db IN ('ISSUE','REVERSED ISSUE')
AND code.transaction_code = tran.transaction_code
AND (tran.source_ref_type != 'CUST ORDER' OR
tran.source_ref_type IS NULL)
AND tran.direction != '0'
Thanks
Kind regards
Chanaka