APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_TRANSACTION_DETAILS_V

Line 1030: From mtl_transaction_details_v

1026: , transaction_uom
1027: , transaction_quantity
1028: , transaction_type_id
1029: , trading_partner
1030: From mtl_transaction_details_v
1031: Where object_id = p_lot_attributes_rec.object_id
1032: Order by transaction_date asc;
1033:
1034: Cursor get_type_name IS

Line 1341: from mtl_transaction_details_v

1337: , task
1338: , lpn_number
1339: , transfer_lpn_number
1340: , content_lpn_number
1341: from mtl_transaction_details_v
1342: where object_id = p_material_txn_rec.object_id
1343: and object_type = p_material_txn_rec.object_type
1344: and organization_id = p_material_txn_rec.current_org_id
1345: ;

Line 1424: l_from := ' from mtl_transaction_details_v';

1420: ||' and object_type = '||p_material_txn_rec.object_type
1421: ||' and organization_id = '||p_material_txn_rec.current_org_id
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';