DBA Data[Home] [Help]

APPS.PJM_COMMON_PROJ_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 53: update mtl_material_transactions mmt

49: Begin
50:
51: For crec in c loop
52:
53: update mtl_material_transactions mmt
54: set mmt.project_id =
55: nvl(mmt.project_id , crec.common_project_id)
56: , mmt.source_project_id =
57: nvl(mmt.source_project_id,

Line 73: update mtl_material_transactions mmt

69: --
70: -- This update is for subinventory transfers and direct org
71: -- transfers only
72: --
73: update mtl_material_transactions mmt
74: set mmt.to_project_id = crec.common_project_id
75: where mmt.pm_cost_collected = 'N'
76: and transfer_organization_id = crec.organization_id
77: and transaction_action_id not in ( 12 , 21 )

Line 83: update mtl_material_transactions mmt

79:
80: --
81: -- This update is for intransit transfers only
82: --
83: update mtl_material_transactions mmt
84: set mmt.to_project_id = crec.common_project_id
85: where mmt.pm_cost_collected = 'N'
86: and transaction_action_id in ( 12 , 21 )
87: and to_project_id is null