DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on MTL_TXN_REQUEST_HEADERS

Line 720: FROM mtl_txn_request_headers

716: source. Bug 4237802 */
717: ELSIF p_trx_src_type = 4 THEN -- Move Orders
718: SELECT request_number
719: INTO l_trx_src
720: FROM mtl_txn_request_headers
721: WHERE header_id = p_trx_src_id;
722: ELSIF p_trx_src_type = 5 THEN -- WIP
723: SELECT wip_entity_name
724: INTO l_trx_src

Line 765: FROM mtl_txn_request_headers

761: FROM mtl_txn_request_lines mol
762: WHERE txn_source_id = p_trx_src_id
763: AND organization_id = p_org_id
764: AND EXISTS(SELECT NULL
765: FROM mtl_txn_request_headers
766: WHERE header_id = mol.header_id
767: AND move_order_type = 5
768: AND mol.transaction_source_type_id = 13);
769: