View: OKS_ORDER_V

Product:	OKS - Service Contracts
Description:	view for contract details
Implementation/DBA Data:	APPS.OKS_ORDER_V

View Text

SELECT KOD.ID
, KOD.ORDER_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 = SYS_CONTEXT('OKC_CONTEXT'
, 'ORG_ID')
AND MTL.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT'
, 'ORGANIZATION_ID')

Columns