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 MTL_CROSS_REFERENCES

Line 56: FROM mtl_cross_references_vl mcr

52: 0 v_parent_rlevel ,
53: msi.lot_control_code ,
54: msi.serial_number_control_code ,
55: decode(( SELECT upper(mcr.cross_reference)
56: FROM mtl_cross_references_vl mcr
57: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
58: AND mcr.organization_id = msi.organization_id + 0
59: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
60: FROM mtl_cross_references_vl mcr1

Line 60: FROM mtl_cross_references_vl mcr1

56: FROM mtl_cross_references_vl mcr
57: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
58: AND mcr.organization_id = msi.organization_id + 0
59: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
60: FROM mtl_cross_references_vl mcr1
61: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
62: AND mcr1.organization_id = msi.organization_id + 0
63: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
64: (SELECT mcr.attribute1

Line 65: FROM mtl_cross_references_vl mcr

61: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
62: AND mcr1.organization_id = msi.organization_id + 0
63: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
64: (SELECT mcr.attribute1
65: FROM mtl_cross_references_vl mcr
66: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
67: AND mcr.organization_id = (SELECT master_organization_id
68: FROM mtl_parameters
69: WHERE organization_id = msi.organization_id + 0)

Line 109: FROM mtl_cross_references_vl mcr

105: 0 v_parent_rlevel ,
106: msi.lot_control_code ,
107: msi.serial_number_control_code ,
108: decode(( SELECT upper(mcr.cross_reference)
109: FROM mtl_cross_references_vl mcr
110: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
111: AND mcr.organization_id = msi.organization_id+0
112: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
113: FROM mtl_cross_references_vl mcr1

Line 113: FROM mtl_cross_references_vl mcr1

109: FROM mtl_cross_references_vl mcr
110: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
111: AND mcr.organization_id = msi.organization_id+0
112: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
113: FROM mtl_cross_references_vl mcr1
114: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
115: AND mcr1.organization_id = msi.organization_id+0
116: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
117: (SELECT mcr.attribute1

Line 118: FROM mtl_cross_references_vl mcr

114: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
115: AND mcr1.organization_id = msi.organization_id+0
116: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
117: (SELECT mcr.attribute1
118: FROM mtl_cross_references_vl mcr
119: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
120: AND mcr.organization_id = (SELECT master_organization_id
121: FROM mtl_parameters
122: WHERE organization_id=msi.organization_id+0)

Line 168: FROM mtl_cross_references_vl mcr

164: abs(mmt.transaction_quantity) transaction_quantity,
165: msi.lot_control_code ,
166: msi.serial_number_control_code ,
167: decode(( SELECT upper(mcr.cross_reference)
168: FROM mtl_cross_references_vl mcr
169: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
170: AND mcr.organization_id = msi.organization_id+0
171: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
172: FROM mtl_cross_references_vl mcr1

Line 172: FROM mtl_cross_references_vl mcr1

168: FROM mtl_cross_references_vl mcr
169: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
170: AND mcr.organization_id = msi.organization_id+0
171: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
172: FROM mtl_cross_references_vl mcr1
173: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
174: AND mcr1.organization_id = msi.organization_id+0
175: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
176: (SELECT mcr.attribute1

Line 177: FROM mtl_cross_references_vl mcr

173: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
174: AND mcr1.organization_id = msi.organization_id+0
175: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
176: (SELECT mcr.attribute1
177: FROM mtl_cross_references_vl mcr
178: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
179: AND mcr.organization_id = (SELECT master_organization_id
180: FROM mtl_parameters
181: WHERE organization_id=msi.organization_id+0)

Line 288: FROM mtl_cross_references_vl mcr

284: msi.organization_id ,
285: msi.lot_control_code ,
286: msi.serial_number_control_code ,
287: decode(( SELECT upper(mcr.cross_reference)
288: FROM mtl_cross_references_vl mcr
289: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
290: AND mcr.organization_id = msi.organization_id + 0
291: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
292: FROM mtl_cross_references_vl mcr1

Line 292: FROM mtl_cross_references_vl mcr1

288: FROM mtl_cross_references_vl mcr
289: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
290: AND mcr.organization_id = msi.organization_id + 0
291: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
292: FROM mtl_cross_references_vl mcr1
293: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
294: AND mcr1.organization_id = msi.organization_id + 0
295: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
296: (SELECT mcr.attribute1

Line 297: FROM mtl_cross_references_vl mcr

293: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
294: AND mcr1.organization_id = msi.organization_id + 0
295: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
296: (SELECT mcr.attribute1
297: FROM mtl_cross_references_vl mcr
298: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
299: AND mcr.organization_id = (SELECT master_organization_id
300: FROM mtl_parameters
301: WHERE organization_id = msi.organization_id + 0)

Line 309: mtl_cross_references mcr

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
313: AND we.wip_entity_id = msn.original_wip_entity_id

Line 2394: FROM mtl_cross_references_vl mcr

2390: 0 v_parent_rlevel ,
2391: msi.lot_control_code ,
2392: msi.serial_number_control_code ,
2393: decode(( SELECT upper(mcr.cross_reference)
2394: FROM mtl_cross_references_vl mcr
2395: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2396: AND mcr.organization_id = msi.organization_id + 0
2397: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
2398: FROM mtl_cross_references_vl mcr1

Line 2398: FROM mtl_cross_references_vl mcr1

2394: FROM mtl_cross_references_vl mcr
2395: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2396: AND mcr.organization_id = msi.organization_id + 0
2397: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
2398: FROM mtl_cross_references_vl mcr1
2399: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
2400: AND mcr1.organization_id = msi.organization_id + 0
2401: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
2402: (SELECT mcr.attribute1

Line 2403: FROM mtl_cross_references_vl mcr

2399: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
2400: AND mcr1.organization_id = msi.organization_id + 0
2401: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
2402: (SELECT mcr.attribute1
2403: FROM mtl_cross_references_vl mcr
2404: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2405: AND mcr.organization_id = (SELECT master_organization_id
2406: FROM mtl_parameters
2407: WHERE organization_id = msi.organization_id + 0)

Line 2447: FROM mtl_cross_references_vl mcr

2443: 0 v_parent_rlevel ,
2444: msi.lot_control_code ,
2445: msi.serial_number_control_code ,
2446: decode(( SELECT upper(mcr.cross_reference)
2447: FROM mtl_cross_references_vl mcr
2448: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2449: AND mcr.organization_id = msi.organization_id+0
2450: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
2451: FROM mtl_cross_references_vl mcr1

Line 2451: FROM mtl_cross_references_vl mcr1

2447: FROM mtl_cross_references_vl mcr
2448: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2449: AND mcr.organization_id = msi.organization_id+0
2450: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
2451: FROM mtl_cross_references_vl mcr1
2452: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
2453: AND mcr1.organization_id = msi.organization_id+0
2454: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
2455: (SELECT mcr.attribute1

Line 2456: FROM mtl_cross_references_vl mcr

2452: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
2453: AND mcr1.organization_id = msi.organization_id+0
2454: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
2455: (SELECT mcr.attribute1
2456: FROM mtl_cross_references_vl mcr
2457: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2458: AND mcr.organization_id = (SELECT master_organization_id
2459: FROM mtl_parameters
2460: WHERE organization_id=msi.organization_id+0)

Line 2502: FROM mtl_cross_references_vl mcr

2498: abs(mmt.transaction_quantity) transaction_quantity,
2499: msi.lot_control_code ,
2500: msi.serial_number_control_code ,
2501: decode(( SELECT upper(mcr.cross_reference)
2502: FROM mtl_cross_references_vl mcr
2503: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2504: AND mcr.organization_id = msi.organization_id+0
2505: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
2506: FROM mtl_cross_references_vl mcr1

Line 2506: FROM mtl_cross_references_vl mcr1

2502: FROM mtl_cross_references_vl mcr
2503: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2504: AND mcr.organization_id = msi.organization_id+0
2505: AND to_char(mcr.last_update_date, ''DD/MM/YYYY-HH24.MM.SS'') = (SELECT MAX(to_char(mcr1.last_update_date, ''DD/MM/YYYY-HH24.MM.SS''))
2506: FROM mtl_cross_references_vl mcr1
2507: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
2508: AND mcr1.organization_id = msi.organization_id+0
2509: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
2510: (SELECT mcr.attribute1

Line 2511: FROM mtl_cross_references_vl mcr

2507: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
2508: AND mcr1.organization_id = msi.organization_id+0
2509: AND mcr1.cross_reference_type =''OPSM INTEGRATED'')),''NO'',0,1) cross_reference,
2510: (SELECT mcr.attribute1
2511: FROM mtl_cross_references_vl mcr
2512: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
2513: AND mcr.organization_id = (SELECT master_organization_id
2514: FROM mtl_parameters
2515: WHERE organization_id=msi.organization_id+0)

Line 2622: FROM mtl_cross_references_vl mcr

2618: msi.organization_id ,
2619: msi.lot_control_code ,
2620: msi.serial_number_control_code ,
2621: decode(( SELECT upper(mcr.cross_reference)
2622: FROM mtl_cross_references_vl mcr
2623: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2624: AND mcr.organization_id = msi.organization_id + 0
2625: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
2626: FROM mtl_cross_references_vl mcr1

Line 2626: FROM mtl_cross_references_vl mcr1

2622: FROM mtl_cross_references_vl mcr
2623: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2624: AND mcr.organization_id = msi.organization_id + 0
2625: AND to_char(mcr.last_update_date, 'DD/MM/YYYY-HH24.MM.SS') = (SELECT MAX(to_char(mcr1.last_update_date, 'DD/MM/YYYY-HH24.MM.SS'))
2626: FROM mtl_cross_references_vl mcr1
2627: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
2628: AND mcr1.organization_id = msi.organization_id + 0
2629: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
2630: (SELECT mcr.attribute1

Line 2631: FROM mtl_cross_references_vl mcr

2627: WHERE mcr1.inventory_item_id = msi.inventory_item_id + 0
2628: AND mcr1.organization_id = msi.organization_id + 0
2629: AND mcr1.cross_reference_type ='OPSM INTEGRATED')), 'NO', 0, 1) cross_reference,
2630: (SELECT mcr.attribute1
2631: FROM mtl_cross_references_vl mcr
2632: WHERE mcr.inventory_item_id = msi.inventory_item_id + 0
2633: AND mcr.organization_id = (SELECT master_organization_id
2634: FROM mtl_parameters
2635: WHERE organization_id = msi.organization_id + 0)

Line 2643: mtl_cross_references mcr

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
2647: AND we.wip_entity_id = msn.original_wip_entity_id