APPS.OKS_OMINT_PUB dependencies on OKX_SYSTEM_ITEMS_V

Line 304: From OKX_SYSTEM_ITEMS_V

300: AND rownum < 2; */
301:
302: Cursor l_servicable_prod_csr (p_item_id Number, l_organization_id Number) Is
303: Select serviceable_product_flag
304: From OKX_SYSTEM_ITEMS_V
305: Where id1 = p_item_id
306: And id2 = l_organization_id;
307: --end npalepu
308:

Line 312: From OKX_SYSTEM_ITEMS_V

308:
309: /* start fixes 4605912
310: Cursor l_servicable_prod_csr (p_item_id Number, l_organization_id Number) Is
311: Select serviceable_product_flag
312: From OKX_SYSTEM_ITEMS_V
313: Where id1 = p_item_id
314: And id2 = l_organization_id;
315: end fixes 4605912 */
316:

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