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_VL

Line 252: FROM mtl_cross_references_vl mcr

248: 0 v_parent_rlevel ,
249: msi.lot_control_code ,
250: msi.serial_number_control_code ,
251: decode(( SELECT upper(mcr.cross_reference)
252: FROM mtl_cross_references_vl mcr
253: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
254: AND mcr.organization_id = msi.organization_id+0
255: 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'))
256: FROM mtl_cross_references_vl mcr1

Line 256: FROM mtl_cross_references_vl mcr1

252: FROM mtl_cross_references_vl mcr
253: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
254: AND mcr.organization_id = msi.organization_id+0
255: 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'))
256: FROM mtl_cross_references_vl mcr1
257: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
258: AND mcr1.organization_id = msi.organization_id+0
259: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
260: (SELECT mcr.attribute1

Line 261: FROM mtl_cross_references_vl mcr

257: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
258: AND mcr1.organization_id = msi.organization_id+0
259: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
260: (SELECT mcr.attribute1
261: FROM mtl_cross_references_vl mcr
262: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
263: AND mcr.organization_id = (SELECT master_organization_id
264: FROM mtl_parameters
265: WHERE organization_id=msi.organization_id+0)

Line 324: FROM mtl_cross_references_vl mcr

320: 0 v_parent_rlevel ,
321: msi.lot_control_code ,
322: msi.serial_number_control_code ,
323: decode(( SELECT upper(mcr.cross_reference)
324: FROM mtl_cross_references_vl mcr
325: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
326: AND mcr.organization_id = msi.organization_id+0
327: 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'))
328: FROM mtl_cross_references_vl mcr1

Line 328: FROM mtl_cross_references_vl mcr1

324: FROM mtl_cross_references_vl mcr
325: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
326: AND mcr.organization_id = msi.organization_id+0
327: 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'))
328: FROM mtl_cross_references_vl mcr1
329: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
330: AND mcr1.organization_id = msi.organization_id+0
331: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
332: (SELECT mcr.attribute1

Line 333: FROM mtl_cross_references_vl mcr

329: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
330: AND mcr1.organization_id = msi.organization_id+0
331: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
332: (SELECT mcr.attribute1
333: FROM mtl_cross_references_vl mcr
334: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
335: AND mcr.organization_id = (SELECT master_organization_id
336: FROM mtl_parameters
337: WHERE organization_id=msi.organization_id+0)

Line 397: FROM mtl_cross_references_vl mcr

393: 0 v_parent_rlevel ,
394: msi.lot_control_code ,
395: msi.serial_number_control_code ,
396: decode(( SELECT upper(mcr.cross_reference)
397: FROM mtl_cross_references_vl mcr
398: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
399: AND mcr.organization_id = msi.organization_id+0
400: 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'))
401: FROM mtl_cross_references_vl mcr1

Line 401: FROM mtl_cross_references_vl mcr1

397: FROM mtl_cross_references_vl mcr
398: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
399: AND mcr.organization_id = msi.organization_id+0
400: 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'))
401: FROM mtl_cross_references_vl mcr1
402: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
403: AND mcr1.organization_id = msi.organization_id+0
404: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
405: (SELECT mcr.attribute1

Line 406: FROM mtl_cross_references_vl mcr

402: WHERE mcr1.inventory_item_id = msi.inventory_item_id+0
403: AND mcr1.organization_id = msi.organization_id+0
404: AND mcr1.cross_reference_type ='OPSM INTEGRATED')),'NO',0,1) cross_reference,
405: (SELECT mcr.attribute1
406: FROM mtl_cross_references_vl mcr
407: WHERE mcr.inventory_item_id = msi.inventory_item_id+0
408: AND mcr.organization_id = (SELECT master_organization_id
409: FROM mtl_parameters
410: WHERE organization_id=msi.organization_id+0)