DBA Data[Home] [Help]

APPS.INV_RCV_RESERVATION_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3020: , mtl_material_transactions_temp mmtt

3016: , mtrl.reference
3017: , mtrl.reference_type_code
3018: , mtrl.reference_id
3019: FROM mtl_txn_request_lines mtrl
3020: , mtl_material_transactions_temp mmtt
3021: WHERE mtrl.organization_id = p_org_id
3022: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3023: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)
3024: AND (nvl(mtrl.project_id,-1) = nvl(p_project_id,-1)

Line 3129: , mtl_material_transactions_temp mmtt

3125: FROM dual
3126: WHERE exists
3127: (SELECT 1
3128: FROM wms_dispatched_tasks wdt
3129: , mtl_material_transactions_temp mmtt
3130: WHERE mmtt.move_order_line_id = l_mol_rec.line_id
3131: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
3132: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)
3133: OR (transaction_source_type_id = 12 AND transaction_action_id = 27))