VIEW: APPS.OKS_ORDER_V

Source

View Text - Preformatted

SELECT kod.id ,kod.order_line_id1 ,Kod.link_ord_line_id1 ,oh.order_number ,ol.line_number ,mtl.name ,ol.service_start_date ,ol.service_end_date ,kod.object_version_number from oks_k_order_details kod ,okx_order_lines_v ol ,okx_order_headers_v oh ,okx_system_items_v mtl WHERE to_number(kod.order_line_id1) = ol.id1 and ol.header_id = oh.id1 and ol.inventory_item_id = mtl.id1 and ol.org_id = okc_context.get_okc_org_id and mtl.organization_id = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')

View Text - HTML Formatted

SELECT KOD.ID
, KOD.ORDER_LINE_ID1
, KOD.LINK_ORD_LINE_ID1
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, MTL.NAME
, OL.SERVICE_START_DATE
, OL.SERVICE_END_DATE
, KOD.OBJECT_VERSION_NUMBER
FROM OKS_K_ORDER_DETAILS KOD
, OKX_ORDER_LINES_V OL
, OKX_ORDER_HEADERS_V OH
, OKX_SYSTEM_ITEMS_V MTL
WHERE TO_NUMBER(KOD.ORDER_LINE_ID1) = OL.ID1
AND OL.HEADER_ID = OH.ID1
AND OL.INVENTORY_ITEM_ID = MTL.ID1
AND OL.ORG_ID = OKC_CONTEXT.GET_OKC_ORG_ID
AND MTL.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT'
, 'ORGANIZATION_ID')