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 2004: --npalepu 23-dec-2005 for bug # 4897884 removed MTL_UNITS_OF_MEASURE_VL uom,

2000: )
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,

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 2026: MTL_UNITS_OF_MEASURE_VL uom,

2022: srvuom.description Service_duration_period_mean,
2023: kfv.shippable_item_flag shippable_item_flag,
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'

Line 2027: MTL_UNITS_OF_MEASURE_VL srvuom,

2023: kfv.shippable_item_flag shippable_item_flag,
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'

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

2050: AND fnd1.language = USERENV('LANG')
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,

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 2076: MTL_UNITS_OF_MEASURE_VL uom,

2072: srvuom.description Service_duration_period_mean,
2073: kfv.shippable_item_flag shippable_item_flag,
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'

Line 2077: MTL_UNITS_OF_MEASURE_VL srvuom,

2073: kfv.shippable_item_flag shippable_item_flag,
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'