APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_PENDING_TXNS_MFG_LOTS_V

Line 1571: from mtl_pending_txns_mfg_lots_v

1567: , lpn_number
1568: , transfer_lpn_number
1569: , content_lpn_number
1570: , transaction_status
1571: from mtl_pending_txns_mfg_lots_v
1572: where object_id = p_pending_txn_rec.object_id
1573: and object_type = p_pending_txn_rec.object_type
1574: and organization_id = p_pending_txn_rec.current_org_id
1575: ;

Line 1604: l_from := ' from mtl_pending_txns_mfg_lots_v';

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:
1607: l_order_by := ' order by transaction_date desc';
1608: l_query := l_select||l_from||l_where||l_order_by;