DBA Data[Home] [Help]

APPS.INV_RCV_RESERVATION_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2814: , mtl_material_transactions_temp mmtt

2810: , mtrl.reference
2811: , mtrl.reference_type_code
2812: , mtrl.reference_id
2813: FROM mtl_txn_request_lines mtrl
2814: , mtl_material_transactions_temp mmtt
2815: WHERE mtrl.organization_id = p_org_id
2816: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
2817: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
2818: AND (nvl(mtrl.project_id,-1) = nvl(p_project_id,-1)

Line 2923: , mtl_material_transactions_temp mmtt

2919: FROM dual
2920: WHERE exists
2921: (SELECT 1
2922: FROM wms_dispatched_tasks wdt
2923: , mtl_material_transactions_temp mmtt
2924: WHERE mmtt.move_order_line_id = l_mol_rec.line_id
2925: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
2926: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)
2927: OR (transaction_source_type_id = 12 AND transaction_action_id = 27))