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 2025: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,

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

Line 2075: FROM MTL_SYSTEM_ITEMS_B_KFV kfv,

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