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 1480: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL

1476: WHERE flex_value_id = p_flex_value_id
1477: AND enabled_flag = 'Y'
1478: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1479:
1480: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL
1481: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1482: select 'X'
1483: from MTL_SYSTEM_ITEMS_VL
1484: where organization_id =

Line 1483: from MTL_SYSTEM_ITEMS_VL

1479:
1480: --Bug 5721543 New cursor for checking Item value against MTL_SYSTEM_ITEMS_VL
1481: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1482: select 'X'
1483: from MTL_SYSTEM_ITEMS_VL
1484: where organization_id =
1485: TO_NUMBER(oe_sys_parameters.value('MASTER_ORGANIZATION_ID', to_number(fnd_profile.value('ORG_ID'))))
1486: AND (bom_item_type = 1 OR bom_item_type = 4)
1487: AND vendor_warranty_flag = 'N'