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

Line 1442: okx_system_items_v mtl

1438: ol.schedule_ship_date,
1439: mtl.service_starting_delay
1440: FROM csi_item_instances csi,
1441: oe_order_lines_all ol,
1442: okx_system_items_v mtl
1443: WHERE csi.inventory_item_id = mtl.id1
1444: AND ol.inventory_item_id = csi.inventory_item_id
1445: AND mtl.id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID
1446: AND csi.last_oe_order_line_id = ol.line_id