DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_INV_TXNS_MFG_LOTS_V

Line 1389: from mtl_inv_txns_mfg_lots_v

1385: , task
1386: , lpn_number
1387: , transfer_lpn_number
1388: , content_lpn_number
1389: from mtl_inv_txns_mfg_lots_v
1390: where object_id = p_material_txn_rec.object_id
1391: and object_type = p_material_txn_rec.object_type
1392: and organization_id = p_material_txn_rec.current_org_id
1393: ;

Line 1426: l_from := ' from mtl_inv_txns_mfg_lots_v';

1422: ;
1423: if p_material_txn_rec.object_type <> 5 then
1424: l_from := ' from mtl_transaction_details_v';
1425: elsif p_material_txn_rec.wip_entity_type in (9, 10) then
1426: l_from := ' from mtl_inv_txns_mfg_lots_v';
1427: else
1428: l_from := ' from wsm_inv_txns_wip_lots_v';
1429: end if;
1430: l_order_by := ' order by transaction_date desc';