APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_TRANSACTION_DETAILS_V

Line 1026: From mtl_transaction_details_v

1022: , transaction_uom
1023: , transaction_quantity
1024: , transaction_type_id
1025: , trading_partner
1026: From mtl_transaction_details_v
1027: Where object_id = p_lot_attributes_rec.object_id
1028: Order by transaction_date asc;
1029:
1030: Cursor get_type_name IS

Line 1337: from mtl_transaction_details_v

1333: , task
1334: , lpn_number
1335: , transfer_lpn_number
1336: , content_lpn_number
1337: from mtl_transaction_details_v
1338: where object_id = p_material_txn_rec.object_id
1339: and object_type = p_material_txn_rec.object_type
1340: and organization_id = p_material_txn_rec.current_org_id
1341: ;

Line 1420: l_from := ' from mtl_transaction_details_v';

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