APPS.INV_GENEALOGY_REPORT_GEN dependencies on WSM_INV_TXNS_WIP_LOTS_V

Line 1361: from wsm_inv_txns_wip_lots_v

1357: , task
1358: , lpn_number
1359: , transfer_lpn_number
1360: , content_lpn_number
1361: from wsm_inv_txns_wip_lots_v
1362: where object_id = p_material_txn_rec.object_id
1363: and object_type = p_material_txn_rec.object_type
1364: and organization_id = p_material_txn_rec.current_org_id
1365: ;

Line 1424: l_from := ' from wsm_inv_txns_wip_lots_v';

1420: l_from := ' from mtl_transaction_details_v';
1421: elsif p_material_txn_rec.wip_entity_type in (9, 10) then
1422: l_from := ' from mtl_inv_txns_mfg_lots_v';
1423: else
1424: l_from := ' from wsm_inv_txns_wip_lots_v';
1425: end if;
1426: l_order_by := ' order by transaction_date desc';
1427: l_query := l_select||l_from||l_where||l_order_by;
1428: --debug('Material_txn Query: '||l_query);