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_BE_PKG dependencies on MTL_CROSS_REFERENCES_VL

Line 192: mtl_cross_references_vl mcr,

188: --To check wheather Item is OPSM Integrated or not
189: SELECT 1
190: INTO l_count
191: FROM mtl_system_items_b_kfv msik,
192: mtl_cross_references_vl mcr,
193: mtl_parameters mp
194: WHERE mp.organization_id = msik.organization_id
195: AND msik.inventory_item_id(+) = mcr.inventory_item_id
196: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 203: FROM MTL_CROSS_REFERENCES_VL

199: AND mp.opsm_enabled_FLAG = 'Y'
200: AND msik.lot_control_code = 2
201: AND msik.organization_id = v_cur_item.organization_id
202: AND NOT EXISTS (SELECT 'Y'
203: FROM MTL_CROSS_REFERENCES_VL
204: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
205: AND ORGANIZATION_ID = v_cur_item.organization_id
206: AND INVENTORY_ITEM_ID = msik.inventory_item_id
207: AND UPPER(CROSS_REFERENCE) ='NO')

Line 291: mtl_cross_references_vl mcr,

287: --To check wheather Item is OPSM Integrated or not
288: SELECT 1
289: INTO l_count
290: FROM mtl_system_items_b_kfv msik,
291: mtl_cross_references_vl mcr,
292: mtl_parameters mp
293: WHERE mp.organization_id = msik.organization_id
294: AND msik.inventory_item_id(+) = mcr.inventory_item_id
295: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 302: FROM MTL_CROSS_REFERENCES_VL

298: AND mp.opsm_enabled_FLAG = 'Y'
299: AND msik.lot_control_code = 2
300: AND msik.organization_id = v_cur_item.organization_id
301: AND NOT EXISTS (SELECT 'Y'
302: FROM MTL_CROSS_REFERENCES_VL
303: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
304: AND ORGANIZATION_ID = v_cur_item.organization_id
305: AND INVENTORY_ITEM_ID = msik.inventory_item_id
306: AND UPPER(CROSS_REFERENCE) ='NO')

Line 526: mtl_cross_references_vl mcr,

522: --To check wheather Item is OPSM Integrated or not
523: SELECT 1
524: INTO l_count1
525: FROM mtl_system_items_b_kfv msik,
526: mtl_cross_references_vl mcr,
527: mtl_parameters mp
528: WHERE mp.organization_id = msik.organization_id
529: AND msik.inventory_item_id(+) = mcr.inventory_item_id
530: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 537: FROM MTL_CROSS_REFERENCES_VL

533: AND mp.opsm_enabled_FLAG = 'Y'
534: AND msik.lot_control_code = 2
535: AND msik.organization_id = v_cur_itemgenealogy.organization_id
536: AND NOT EXISTS (SELECT 'Y'
537: FROM MTL_CROSS_REFERENCES_VL
538: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
539: AND ORGANIZATION_ID = v_cur_itemgenealogy.organization_id
540: AND INVENTORY_ITEM_ID = msik.inventory_item_id
541: AND UPPER(CROSS_REFERENCE) ='NO')

Line 689: mtl_cross_references_vl mcr,

685: BEGIN
686: SELECT 1
687: INTO l_count2
688: FROM mtl_system_items_b_kfv msik,
689: mtl_cross_references_vl mcr,
690: mtl_parameters mp
691: WHERE mp.organization_id = msik.organization_id
692: AND msik.inventory_item_id(+) = mcr.inventory_item_id
693: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 700: FROM MTL_CROSS_REFERENCES_VL

696: AND mp.opsm_enabled_FLAG = 'Y'
697: AND msik.lot_control_code = 2
698: AND msik.organization_id = v_organization_id
699: AND NOT EXISTS (SELECT 'Y'
700: FROM MTL_CROSS_REFERENCES_VL
701: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
702: AND ORGANIZATION_ID = v_organization_id
703: AND INVENTORY_ITEM_ID = msik.inventory_item_id
704: AND UPPER(CROSS_REFERENCE) ='NO')

Line 1259: mtl_cross_references_vl mcr,

1255: --To check wheather Item is OPSM Integrated or not
1256: SELECT 1
1257: INTO l_count
1258: FROM mtl_system_items_b_kfv msik,
1259: mtl_cross_references_vl mcr,
1260: mtl_parameters mp
1261: WHERE mp.organization_id = msik.organization_id
1262: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1263: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 1270: FROM MTL_CROSS_REFERENCES_VL

1266: AND mp.opsm_enabled_FLAG = 'Y'
1267: AND msik.lot_control_code = 2
1268: AND msik.organization_id = v_cur_item.organization_id
1269: AND NOT EXISTS (SELECT 'Y'
1270: FROM MTL_CROSS_REFERENCES_VL
1271: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
1272: AND ORGANIZATION_ID = v_cur_item.organization_id
1273: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1274: AND UPPER(CROSS_REFERENCE) ='NO')

Line 1356: mtl_cross_references_vl mcr,

1352: --To check wheather Item is OPSM Integrated or not
1353: SELECT 1
1354: INTO l_count
1355: FROM mtl_system_items_b_kfv msik,
1356: mtl_cross_references_vl mcr,
1357: mtl_parameters mp
1358: WHERE mp.organization_id = msik.organization_id
1359: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1360: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 1367: FROM MTL_CROSS_REFERENCES_VL

1363: AND mp.opsm_enabled_FLAG = 'Y'
1364: AND msik.lot_control_code = 2
1365: AND msik.organization_id = v_cur_item.organization_id
1366: AND NOT EXISTS (SELECT 'Y'
1367: FROM MTL_CROSS_REFERENCES_VL
1368: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
1369: AND ORGANIZATION_ID = v_cur_item.organization_id
1370: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1371: AND UPPER(CROSS_REFERENCE) ='NO')

Line 1591: mtl_cross_references_vl mcr,

1587: --To check wheather Item is OPSM Integrated or not
1588: SELECT 1
1589: INTO l_count1
1590: FROM mtl_system_items_b_kfv msik,
1591: mtl_cross_references_vl mcr,
1592: mtl_parameters mp
1593: WHERE mp.organization_id = msik.organization_id
1594: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1595: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 1602: FROM MTL_CROSS_REFERENCES_VL

1598: AND mp.opsm_enabled_FLAG = 'Y'
1599: AND msik.lot_control_code = 2
1600: AND msik.organization_id = v_cur_itemgenealogy.organization_id
1601: AND NOT EXISTS (SELECT 'Y'
1602: FROM MTL_CROSS_REFERENCES_VL
1603: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
1604: AND ORGANIZATION_ID = v_cur_itemgenealogy.organization_id
1605: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1606: AND UPPER(CROSS_REFERENCE) ='NO')

Line 1754: mtl_cross_references_vl mcr,

1750: BEGIN
1751: SELECT 1
1752: INTO l_count2
1753: FROM mtl_system_items_b_kfv msik,
1754: mtl_cross_references_vl mcr,
1755: mtl_parameters mp
1756: WHERE mp.organization_id = msik.organization_id
1757: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1758: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 1765: FROM MTL_CROSS_REFERENCES_VL

1761: AND mp.opsm_enabled_FLAG = 'Y'
1762: AND msik.lot_control_code = 2
1763: AND msik.organization_id = v_organization_id
1764: AND NOT EXISTS (SELECT 'Y'
1765: FROM MTL_CROSS_REFERENCES_VL
1766: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
1767: AND ORGANIZATION_ID = v_organization_id
1768: AND INVENTORY_ITEM_ID = msik.inventory_item_id
1769: AND UPPER(CROSS_REFERENCE) ='NO')

Line 2187: mtl_cross_references_vl mcr,

2183: BEGIN
2184: SELECT 1
2185: INTO l_count
2186: FROM mtl_system_items_b_kfv msik,
2187: mtl_cross_references_vl mcr,
2188: mtl_parameters mp
2189: WHERE mp.organization_id = msik.organization_id
2190: AND msik.inventory_item_id(+) = mcr.inventory_item_id
2191: AND mcr.cross_reference_type = 'OPSM INTEGRATED'

Line 2198: FROM MTL_CROSS_REFERENCES_VL

2194: AND mp.opsm_enabled_FLAG = 'Y'
2195: AND msik.lot_control_code = 2
2196: AND msik.organization_id = v_opsm_items.organization_id
2197: AND NOT EXISTS (SELECT 'Y'
2198: FROM MTL_CROSS_REFERENCES_VL
2199: WHERE CROSS_REFERENCE_TYPE = 'OPSM INTEGRATED'
2200: AND ORGANIZATION_ID = v_opsm_items.organization_id
2201: AND INVENTORY_ITEM_ID = msik.inventory_item_id
2202: AND UPPER(CROSS_REFERENCE) ='NO')