APPS.OKS_OMINT_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 735: From MTL_SYSTEM_ITEMS_B_KFV

731: /* Cursor l_srv_csr Is */
732: Cursor l_srv_csr(v_organization_id IN NUMBER) Is
733: --end 4897884
734: Select INVENTORY_ITEM_ID id1
735: From MTL_SYSTEM_ITEMS_B_KFV
736: Where VENDOR_WARRANTY_FLAG = 'N'
737: And SERVICE_ITEM_FLAG = 'Y'
738: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
739: AND DECODE(ENABLED_FLAG,'Y','A','I') = 'A'

Line 940: From MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T --OKX_SYSTEM_ITEMS_V

936: Select B.INVENTORY_ITEM_ID Id1,
937: T.DESCRIPTION Name,
938: B.CONCATENATED_SEGMENTS Description,
939: B.COVERAGE_SCHEDULE_ID COVERAGE_TEMPLATE_ID
940: From MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T --OKX_SYSTEM_ITEMS_V
941: Where B.SERVICE_ITEM_FLAG='Y'
942: And B.VENDOR_WARRANTY_FLAG = 'N'
943: And B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
944: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID

Line 2072: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,

2068: kfv.service_duration_period_code Service_duration_period_code,
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

Line 2122: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,

2118: kfv.service_duration_period_code Service_duration_period_code,
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