APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_PENDING_TXN_DETAILS_V

Line 1542: from mtl_pending_txn_details_v

1538: , lpn_number
1539: , transfer_lpn_number
1540: , content_lpn_number
1541: , transaction_status
1542: from mtl_pending_txn_details_v
1543: where object_id = p_pending_txn_rec.object_id
1544: and object_type = p_pending_txn_rec.object_type
1545: and organization_id = p_pending_txn_rec.current_org_id
1546: ;

Line 1598: l_from := ' from mtl_pending_txn_details_v';

1594: ||' and object_type = '||p_pending_txn_rec.object_type
1595: ||' and organization_id = '||p_pending_txn_rec.current_org_id
1596: ;
1597: if p_pending_txn_rec.object_type <> 5 then
1598: l_from := ' from mtl_pending_txn_details_v';
1599: else
1600: l_from := ' from mtl_pending_txns_mfg_lots_v';
1601: end if;
1602: