DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_INV_TXNS_MFG_LOTS_V

Line 1385: from mtl_inv_txns_mfg_lots_v

1381: , task
1382: , lpn_number
1383: , transfer_lpn_number
1384: , content_lpn_number
1385: from mtl_inv_txns_mfg_lots_v
1386: where object_id = p_material_txn_rec.object_id
1387: and object_type = p_material_txn_rec.object_type
1388: and organization_id = p_material_txn_rec.current_org_id
1389: ;

Line 1422: l_from := ' from mtl_inv_txns_mfg_lots_v';

1418: ;
1419: if p_material_txn_rec.object_type <> 5 then
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';