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 ORG_ORGANIZATION_DEFINITIONS

Line 135: org_organization_definitions ood ,

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
139: WHERE mmt.transaction_source_id+0 = we.wip_entity_id

Line 195: org_organization_definitions ood ,

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

Line 308: org_organization_definitions ood,

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
312: AND msi.organization_id = we.organization_id + 0

Line 330: org_organization_definitions ood

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
334: AND mmt.transaction_action_id = 31

Line 2469: org_organization_definitions ood ,

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
2473: WHERE mmt.transaction_source_id+0 = we.wip_entity_id

Line 2529: org_organization_definitions ood ,

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

Line 2642: org_organization_definitions ood,

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
2646: AND msi.organization_id = we.organization_id + 0

Line 2664: org_organization_definitions ood

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
2668: AND mmt.transaction_action_id = 31