APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_SYSTEM_ITEMS_VL

Line 75: FROM mtl_system_items_vl msi ,

71: AND mcr.cross_reference = 'YES') serial_type,
72: NULL parent_lot_number ,
73: NULL parent_serial_number ,
74: 0 parent_inventory_item_id
75: FROM mtl_system_items_vl msi ,
76: mtl_lot_numbers mln ,
77: wsh_opsm_asn_item_details_v waid ,
78: wsh_delivery_details wdd
79: WHERE wdd.delivery_detail_id = p_delivery_detail_id

Line 134: mtl_system_items_vl msi ,

130: to_number(null) DELIVERY_ID,
131: to_number(null) GENEALOGY_OBJECT_ID
132: FROM mtl_transaction_lot_numbers mtln ,
133: wip_entities we ,
134: mtl_system_items_vl msi ,
135: org_organization_definitions ood ,
136: mtl_material_transactions mmt ,
137: mtl_object_genealogy mog ,
138: mtl_lot_numbers mln

Line 194: mtl_system_items_vl msi ,

190: mtl_material_transactions mmt ,
191: mtl_transaction_lot_numbers mtln ,
192: mtl_unit_transactions mut ,
193: wip_entities we ,
194: mtl_system_items_vl msi ,
195: org_organization_definitions ood ,
196: mtl_lot_numbers mln
197: WHERE mtln1.transaction_id+0 = mmt1.transaction_id
198: AND mut1.transaction_id+0 = mtln1.serial_transaction_id

Line 305: mtl_system_items_vl msi ,

301: WHERE organization_id = msi.organization_id + 0)
302: AND mcr.cross_reference_type ='OPSM INTEGRATED'
303: AND mcr.cross_reference = 'YES') serial_type
304: FROM wip_entities we ,
305: mtl_system_items_vl msi ,
306: mtl_serial_numbers msn ,
307: mtl_lot_numbers mtln ,
308: org_organization_definitions ood,
309: mtl_cross_references mcr

Line 325: mtl_system_items_vl msi ,

321: SELECT waid.genealogy_object_id
322: FROM mtl_object_genealogy mog ,
323: mtl_material_transactions mmt ,
324: wip_entities we ,
325: mtl_system_items_vl msi ,
326: wsh_opsm_asn_item_details_v waid ,
327: mtl_transaction_lot_numbers mtln ,
328: mtl_unit_transactions mut ,
329: mtl_lot_numbers mln ,

Line 2413: FROM mtl_system_items_vl msi ,

2409: AND mcr.cross_reference = 'YES') serial_type,
2410: NULL parent_lot_number ,
2411: NULL parent_serial_number ,
2412: 0 parent_inventory_item_id
2413: FROM mtl_system_items_vl msi ,
2414: mtl_lot_numbers mln ,
2415: wsh_opsm_asn_item_details_v waid ,
2416: wsh_delivery_details wdd
2417: WHERE wdd.delivery_detail_id = p_delivery_detail_id

Line 2468: mtl_system_items_vl msi ,

2464: NULL parent_serial_number ,
2465: 0 parent_inventory_item_id
2466: FROM mtl_transaction_lot_numbers mtln ,
2467: wip_entities we ,
2468: mtl_system_items_vl msi ,
2469: org_organization_definitions ood ,
2470: mtl_material_transactions mmt ,
2471: mtl_object_genealogy mog ,
2472: mtl_lot_numbers mln

Line 2528: mtl_system_items_vl msi ,

2524: mtl_material_transactions mmt ,
2525: mtl_transaction_lot_numbers mtln ,
2526: mtl_unit_transactions mut ,
2527: wip_entities we ,
2528: mtl_system_items_vl msi ,
2529: org_organization_definitions ood ,
2530: mtl_lot_numbers mln
2531: WHERE mtln1.transaction_id+0 = mmt1.transaction_id
2532: AND mut1.transaction_id+0 = mtln1.serial_transaction_id

Line 2639: mtl_system_items_vl msi ,

2635: WHERE organization_id = msi.organization_id + 0)
2636: AND mcr.cross_reference_type ='OPSM INTEGRATED'
2637: AND mcr.cross_reference = 'YES') serial_type
2638: FROM wip_entities we ,
2639: mtl_system_items_vl msi ,
2640: mtl_serial_numbers msn ,
2641: mtl_lot_numbers mtln ,
2642: org_organization_definitions ood,
2643: mtl_cross_references mcr

Line 2659: mtl_system_items_vl msi ,

2655: SELECT waid.genealogy_object_id
2656: FROM mtl_object_genealogy mog ,
2657: mtl_material_transactions mmt ,
2658: wip_entities we ,
2659: mtl_system_items_vl msi ,
2660: wsh_opsm_asn_item_details_v waid ,
2661: mtl_transaction_lot_numbers mtln ,
2662: mtl_unit_transactions mut ,
2663: mtl_lot_numbers mln ,