DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_TXN_REQUEST_LINES

Line 37: FROM mtl_system_items msi, mtl_txn_request_lines mtrl

33: AND msi.inventory_item_id = mmtt.inventory_item_id
34: AND msi.organization_id = mmtt.organization_id
35: UNION ALL
36: SELECT msi.lot_control_code, msi.serial_number_control_code
37: FROM mtl_system_items msi, mtl_txn_request_lines mtrl
38: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
39: AND mtrl.line_id = p_mo_line_id
40: AND msi.inventory_item_id = mtrl.inventory_item_id
41: AND msi.organization_id = mtrl.organization_id;