eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on WIP_ENTITIES

Line 133: wip_entities we ,

129: to_number(null) DELIVERY_DETAIL_ID,
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 ,

Line 193: wip_entities we ,

189: mtl_unit_transactions mut1 ,
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

Line 236: wip_entities we

232: mtl_transaction_lot_numbers mtln ,
233: mtl_unit_transactions mut ,
234: mtl_serial_numbers msn ,
235: mtl_material_transactions mmt ,
236: wip_entities we
237: WHERE msn.serial_number = r_serial_number
238: AND msn.inventory_item_id = r_item_id
239: AND mut.serial_number = r_serial_number
240: AND mut.inventory_item_id = r_item_id

Line 304: FROM wip_entities we ,

300: FROM mtl_parameters
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,

Line 324: wip_entities we ,

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 ,
327: mtl_transaction_lot_numbers mtln ,
328: mtl_unit_transactions mut ,

Line 2467: wip_entities we ,

2463: NULL parent_lot_number ,
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 ,

Line 2527: wip_entities we ,

2523: mtl_unit_transactions mut1 ,
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

Line 2570: wip_entities we

2566: mtl_transaction_lot_numbers mtln ,
2567: mtl_unit_transactions mut ,
2568: mtl_serial_numbers msn ,
2569: mtl_material_transactions mmt ,
2570: wip_entities we
2571: WHERE msn.serial_number = r_serial_number
2572: AND msn.inventory_item_id = r_item_id
2573: AND mut.serial_number = r_serial_number
2574: AND mut.inventory_item_id = r_item_id

Line 2638: FROM wip_entities we ,

2634: FROM mtl_parameters
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,

Line 2658: wip_entities we ,

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 ,
2661: mtl_transaction_lot_numbers mtln ,
2662: mtl_unit_transactions mut ,