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_SYSTEM_ITEMS_B_KFV

Line 191: FROM mtl_system_items_b_kfv msik,

187: BEGIN
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

Line 290: FROM mtl_system_items_b_kfv msik,

286: BEGIN
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

Line 525: FROM mtl_system_items_b_kfv msik,

521: BEGIN
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

Line 688: FROM mtl_system_items_b_kfv msik,

684: ELSE
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

Line 1258: FROM mtl_system_items_b_kfv msik,

1254: BEGIN
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

Line 1355: FROM mtl_system_items_b_kfv msik,

1351: BEGIN
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

Line 1590: FROM mtl_system_items_b_kfv msik,

1586: BEGIN
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

Line 1753: FROM mtl_system_items_b_kfv msik,

1749: ELSE
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

Line 2186: FROM mtl_system_items_b_kfv msik,

2182: --To check wheather Item is OPSM Integrated or not
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