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 MTL_UNITS_OF_MEASURE_VL

Line 2051: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,

2047: )
2048: IS
2049:
2050: --cursor to fetch the services when P_search_input value is not null
2051: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2052: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2053: Cursor l_service_csr(v_organization_id IN NUMBER) Is
2054: SELECT
2055: kfv.organization_id Organization_id,

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

2048: IS
2049:
2050: --cursor to fetch the services when P_search_input value is not null
2051: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2052: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2053: Cursor l_service_csr(v_organization_id IN NUMBER) Is
2054: SELECT
2055: kfv.organization_id Organization_id,
2056: kfv.inventory_item_id id1,

Line 2073: MTL_UNITS_OF_MEASURE_VL uom,

2069: srvuom.description Service_duration_period_mean,
2070: kfv.shippable_item_flag shippable_item_flag,
2071: kfv.returnable_flag Returnable_flag
2072: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2073: MTL_UNITS_OF_MEASURE_VL uom,
2074: MTL_UNITS_OF_MEASURE_VL srvuom,
2075: FND_LOOKUP_VALUES fnd,
2076: FND_LOOKUP_VALUES fnd1
2077: WHERE kfv.vendor_warranty_flag = 'N'

Line 2074: MTL_UNITS_OF_MEASURE_VL srvuom,

2070: kfv.shippable_item_flag shippable_item_flag,
2071: kfv.returnable_flag Returnable_flag
2072: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2073: MTL_UNITS_OF_MEASURE_VL uom,
2074: MTL_UNITS_OF_MEASURE_VL srvuom,
2075: FND_LOOKUP_VALUES fnd,
2076: FND_LOOKUP_VALUES fnd1
2077: WHERE kfv.vendor_warranty_flag = 'N'
2078: AND kfv.service_item_flag = 'Y'

Line 2101: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,

2097: AND fnd1.language = USERENV('LANG')
2098: ORDER BY CONCATENATED_SEGMENTS;
2099:
2100: --cursor to fetch the services when P_search_input value is null
2101: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2102: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2103: Cursor l_service_csr1(v_organization_id IN NUMBER) Is
2104: SELECT
2105: kfv.organization_id Organization_id,

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

2098: ORDER BY CONCATENATED_SEGMENTS;
2099:
2100: --cursor to fetch the services when P_search_input value is null
2101: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,
2102: -- MTL_UNITS_OF_MEASURE_VL srvuom,FND_LOOKUP_VALUES fnd,FND_LOOKUP_VALUES fnd1 tables
2103: Cursor l_service_csr1(v_organization_id IN NUMBER) Is
2104: SELECT
2105: kfv.organization_id Organization_id,
2106: kfv.inventory_item_id id1,

Line 2123: MTL_UNITS_OF_MEASURE_VL uom,

2119: srvuom.description Service_duration_period_mean,
2120: kfv.shippable_item_flag shippable_item_flag,
2121: kfv.returnable_flag Returnable_flag
2122: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2123: MTL_UNITS_OF_MEASURE_VL uom,
2124: MTL_UNITS_OF_MEASURE_VL srvuom,
2125: FND_LOOKUP_VALUES fnd,
2126: FND_LOOKUP_VALUES fnd1
2127: WHERE kfv.vendor_warranty_flag = 'N'

Line 2124: MTL_UNITS_OF_MEASURE_VL srvuom,

2120: kfv.shippable_item_flag shippable_item_flag,
2121: kfv.returnable_flag Returnable_flag
2122: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,
2123: MTL_UNITS_OF_MEASURE_VL uom,
2124: MTL_UNITS_OF_MEASURE_VL srvuom,
2125: FND_LOOKUP_VALUES fnd,
2126: FND_LOOKUP_VALUES fnd1
2127: WHERE kfv.vendor_warranty_flag = 'N'
2128: AND kfv.service_item_flag = 'Y'