APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_PENDING_TXN_DETAILS_V

Line 1546: from mtl_pending_txn_details_v

1542: , lpn_number
1543: , transfer_lpn_number
1544: , content_lpn_number
1545: , transaction_status
1546: from mtl_pending_txn_details_v
1547: where object_id = p_pending_txn_rec.object_id
1548: and object_type = p_pending_txn_rec.object_type
1549: and organization_id = p_pending_txn_rec.current_org_id
1550: ;

Line 1602: l_from := ' from mtl_pending_txn_details_v';

1598: ||' and object_type = '||p_pending_txn_rec.object_type
1599: ||' and organization_id = '||p_pending_txn_rec.current_org_id
1600: ;
1601: if p_pending_txn_rec.object_type <> 5 then
1602: l_from := ' from mtl_pending_txn_details_v';
1603: else
1604: l_from := ' from mtl_pending_txns_mfg_lots_v';
1605: end if;
1606: