DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on MTL_TXN_REQUEST_HEADERS

Line 666: FROM mtl_txn_request_headers

662: source. Bug 4237802 */
663: ELSIF p_trx_src_type = 4 THEN -- Move Orders
664: SELECT request_number
665: INTO l_trx_src
666: FROM mtl_txn_request_headers
667: WHERE header_id = p_trx_src_id;
668: ELSIF p_trx_src_type = 5 THEN -- WIP
669: SELECT wip_entity_name
670: INTO l_trx_src

Line 711: FROM mtl_txn_request_headers

707: FROM mtl_txn_request_lines mol
708: WHERE txn_source_id = p_trx_src_id
709: AND organization_id = p_org_id
710: AND EXISTS(SELECT NULL
711: FROM mtl_txn_request_headers
712: WHERE header_id = mol.header_id
713: AND move_order_type = 5
714: AND mol.transaction_source_type_id = 13);
715: