APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on MTL_OBJECT_GENEALOGY

Line 137: mtl_object_genealogy mog ,

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
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

Line 231: FROM mtl_object_genealogy mog ,

227: mtln.transaction_source_id ,
228: msn.inventory_item_id ,
229: mut.serial_number ,
230: we.wip_entity_name job_name
231: FROM mtl_object_genealogy mog ,
232: mtl_transaction_lot_numbers mtln ,
233: mtl_unit_transactions mut ,
234: mtl_serial_numbers msn ,
235: mtl_material_transactions mmt ,

Line 262: FROM mtl_object_genealogy mog

258: '' serial_number ,
259: '' parent_serial_number ,
260: 0 delivery_id ,
261: 0 rTree
262: FROM mtl_object_genealogy mog
263: WHERE object_type IN (1, 2)
264: AND genealogy_origin = 1
265: AND (end_date_active IS NULL
266: OR TRUNC(end_date_active) >= TRUNC(SYSDATE))

Line 322: FROM mtl_object_genealogy mog ,

318: CURSOR c_sub_main(r_delivery_detail_id IN NUMBER,
319: r_organization_id IN NUMBER)
320: IS
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 ,

Line 2471: mtl_object_genealogy mog ,

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
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

Line 2565: FROM mtl_object_genealogy mog ,

2561: mtln.transaction_source_id ,
2562: msn.inventory_item_id ,
2563: mut.serial_number ,
2564: we.wip_entity_name job_name
2565: FROM mtl_object_genealogy mog ,
2566: mtl_transaction_lot_numbers mtln ,
2567: mtl_unit_transactions mut ,
2568: mtl_serial_numbers msn ,
2569: mtl_material_transactions mmt ,

Line 2596: FROM mtl_object_genealogy mog

2592: '' serial_number ,
2593: '' parent_serial_number ,
2594: 0 delivery_id ,
2595: 0 rTree
2596: FROM mtl_object_genealogy mog
2597: WHERE object_type IN (1, 2)
2598: AND genealogy_origin = 1
2599: AND (end_date_active IS NULL
2600: OR TRUNC(end_date_active) >= TRUNC(SYSDATE))

Line 2656: FROM mtl_object_genealogy mog ,

2652: CURSOR c_sub_main(r_delivery_detail_id IN NUMBER,
2653: r_organization_id IN NUMBER)
2654: IS
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 ,