DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on RCV_SHIPMENT_LINES

Line 882: FROM rcv_shipment_lines rsl,

878: IF l_transaction_action_id = inv_globals.g_action_intransitreceipt AND
879: p_mmtt_rec.transfer_cost_group_id IS NULL THEN
880: SELECT cost_group_id
881: INTO l_transfer_cost_group_id
882: FROM rcv_shipment_lines rsl,
883: rcv_transactions rt
884: WHERE rsl.shipment_line_id = rt.shipment_line_id
885: AND rt.transaction_id = p_mmtt_rec.source_line_id;
886: IF (l_debug = 1) THEN

Line 1401: FROM mtl_material_transactions mmt, rcv_shipment_lines rsl, rcv_transactions rt, MTL_ITEM_LOCATIONS mil

1397: END IF;
1398:
1399: BEGIN
1400: SELECT mil.project_id INTO l_project_id
1401: FROM mtl_material_transactions mmt, rcv_shipment_lines rsl, rcv_transactions rt, MTL_ITEM_LOCATIONS mil
1402: WHERE p_mmtt_rec.source_line_id= rt.transaction_id
1403: AND rt.shipment_line_id=rsl.shipment_line_id
1404: AND rsl.mmt_transaction_id=mmt.transaction_id
1405: AND mil.inventory_location_id=mmt.locator_id