APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_LOT_NUMBERS

Line 76: mtl_lot_numbers mln ,

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
80: AND wdd.organization_id = p_organization_id

Line 138: mtl_lot_numbers mln

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
139: WHERE mmt.transaction_source_id+0 = we.wip_entity_id
140: AND msi.inventory_item_id = mmt.inventory_item_id+0
141: AND msi.organization_id = mmt.organization_id+0
142: AND we.gen_object_id = mog.object_id

Line 196: mtl_lot_numbers mln

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
199: AND mmt1.transaction_type_id = 44
200: AND mmt1.transaction_quantity = 1

Line 307: mtl_lot_numbers mtln ,

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
310: WHERE msn.gen_object_id = r_gen_object_id
311: AND msi.inventory_item_id = msn.inventory_item_id

Line 329: mtl_lot_numbers mln ,

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 ,
330: org_organization_definitions ood
331: WHERE mog.parent_object_id = waid.genealogy_object_id + 0
332: AND mmt.transaction_id = mog.origin_txn_id + 0
333: AND mmt.transaction_type_id = 44

Line 2414: mtl_lot_numbers mln ,

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
2418: AND wdd.organization_id = p_organization_id

Line 2472: mtl_lot_numbers mln

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
2473: WHERE mmt.transaction_source_id+0 = we.wip_entity_id
2474: AND msi.inventory_item_id = mmt.inventory_item_id+0
2475: AND msi.organization_id = mmt.organization_id+0
2476: AND we.gen_object_id = mog.object_id

Line 2530: mtl_lot_numbers mln

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
2533: AND mmt1.transaction_type_id = 44
2534: AND mmt1.transaction_quantity = 1

Line 2641: mtl_lot_numbers mtln ,

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
2644: WHERE msn.gen_object_id = r_gen_object_id
2645: AND msi.inventory_item_id = msn.inventory_item_id

Line 2663: mtl_lot_numbers mln ,

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 ,
2664: org_organization_definitions ood
2665: WHERE mog.parent_object_id = waid.genealogy_object_id + 0
2666: AND mmt.transaction_id = mog.origin_txn_id + 0
2667: AND mmt.transaction_type_id = 44