APPS.WMS_COSTGROUPENGINE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 204: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

200: mmtt.transaction_action_id transaction_action_id, -- swapped the third and fourth parameter for bug 6761233
201: DECODE(transaction_action_id, 3, transfer_organization,
202: 21, transfer_organization,
203: organization_id) TO_ORGANIZATION_ID
204: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
205: MTL_INTERORG_PARAMETERS mip
206: WHERE mip.from_organization_id (+) = mmtt.organization_id
207: AND mip.to_organization_id (+) = mmtt.transfer_organization
208: AND mmtt.transaction_temp_id = p_line_id;

Line 758: UPDATE mtl_material_transactions_temp mmtt

754: --if input_line_type = MMTT
755: if (p_input_type = g_input_mmtt) then
756: --IF Transfer or intransit, update transfer_cost_group_id
757: IF (l_transaction_action_id IN (2,3,28,21)) THEN
758: UPDATE mtl_material_transactions_temp mmtt
759: SET mmtt.transfer_cost_group_id = l_cost_group_id
760: WHERE mmtt.transaction_temp_id = p_line_id;
761:
762: --else, update cost_group_id

Line 764: UPDATE mtl_material_transactions_temp mmtt

760: WHERE mmtt.transaction_temp_id = p_line_id;
761:
762: --else, update cost_group_id
763: ELSE
764: UPDATE mtl_material_transactions_temp mmtt
765: SET mmtt.cost_group_id = l_cost_group_id
766: WHERE mmtt.transaction_temp_id = p_line_id;
767: END IF;
768: