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.OKC_XPRT_QA_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1551: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL

1547: WHERE flex_value_id = p_flex_value_id
1548: AND enabled_flag = 'Y'
1549: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1550:
1551: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL
1552: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1553: select 'X'
1554: from MTL_SYSTEM_ITEMS_VL
1555: where organization_id =

Line 1554: from MTL_SYSTEM_ITEMS_VL

1550:
1551: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL
1552: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1553: select 'X'
1554: from MTL_SYSTEM_ITEMS_VL
1555: where organization_id =
1556: TO_NUMBER(oe_sys_parameters.value('MASTER_ORGANIZATION_ID', to_number(fnd_profile.value('ORG_ID'))))
1557: AND (bom_item_type = 1 OR bom_item_type = 4)
1558: AND vendor_warranty_flag = 'N'