APPS.OKS_OMINT_PUB dependencies on FND_LOOKUP_VALUES

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 2075: FND_LOOKUP_VALUES fnd,

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'
2079: AND kfv.customer_order_enabled_flag = 'Y'

Line 2076: FND_LOOKUP_VALUES fnd1

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'
2079: AND kfv.customer_order_enabled_flag = 'Y'
2080: AND kfv.enabled_flag = 'Y'

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 2125: FND_LOOKUP_VALUES fnd,

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'
2129: AND kfv.customer_order_enabled_flag = 'Y'

Line 2126: FND_LOOKUP_VALUES fnd1

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'
2129: AND kfv.customer_order_enabled_flag = 'Y'
2130: AND kfv.enabled_flag = 'Y'