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.OKS_OMINT_PUB dependencies on FND_LOOKUP_VALUES

Line 2005: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables

2001: IS
2002:
2003: --cursor to fetch the services when P_search_input value is not null
2004: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2005: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2006: Cursor l_service_csr(v_organization_id IN NUMBER) Is
2007: SELECT
2008: kfv.organization_id Organization_id,
2009: kfv.inventory_item_id id1,

Line 2028: FND_LOOKUP_VALUES fnd,

2024: kfv.returnable_flag Returnable_flag
2025: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2026: MTL_UNITS_OF_MEASURE_VL uom,
2027: MTL_UNITS_OF_MEASURE_VL srvuom,
2028: FND_LOOKUP_VALUES fnd,
2029: FND_LOOKUP_VALUES fnd1
2030: WHERE kfv.vendor_warranty_flag = 'N'
2031: AND kfv.service_item_flag = 'Y'
2032: AND kfv.customer_order_enabled_flag = 'Y'

Line 2029: FND_LOOKUP_VALUES fnd1

2025: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2026: MTL_UNITS_OF_MEASURE_VL uom,
2027: MTL_UNITS_OF_MEASURE_VL srvuom,
2028: FND_LOOKUP_VALUES fnd,
2029: FND_LOOKUP_VALUES fnd1
2030: WHERE kfv.vendor_warranty_flag = 'N'
2031: AND kfv.service_item_flag = 'Y'
2032: AND kfv.customer_order_enabled_flag = 'Y'
2033: AND kfv.enabled_flag = 'Y'

Line 2055: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables

2051: ORDER BY CONCATENATED_SEGMENTS;
2052:
2053: --cursor to fetch the services when P_search_input value is null
2054: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2055: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2056: Cursor l_service_csr1(v_organization_id IN NUMBER) Is
2057: SELECT
2058: kfv.organization_id Organization_id,
2059: kfv.inventory_item_id id1,

Line 2078: FND_LOOKUP_VALUES fnd,

2074: kfv.returnable_flag Returnable_flag
2075: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2076: MTL_UNITS_OF_MEASURE_VL uom,
2077: MTL_UNITS_OF_MEASURE_VL srvuom,
2078: FND_LOOKUP_VALUES fnd,
2079: FND_LOOKUP_VALUES fnd1
2080: WHERE kfv.vendor_warranty_flag = 'N'
2081: AND kfv.service_item_flag = 'Y'
2082: AND kfv.customer_order_enabled_flag = 'Y'

Line 2079: FND_LOOKUP_VALUES fnd1

2075: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2076: MTL_UNITS_OF_MEASURE_VL uom,
2077: MTL_UNITS_OF_MEASURE_VL srvuom,
2078: FND_LOOKUP_VALUES fnd,
2079: FND_LOOKUP_VALUES fnd1
2080: WHERE kfv.vendor_warranty_flag = 'N'
2081: AND kfv.service_item_flag = 'Y'
2082: AND kfv.customer_order_enabled_flag = 'Y'
2083: AND kfv.enabled_flag = 'Y'