[Home] [Help]
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
Name |
ID |
ORDER_LINE_ID1 |
ORDER_NUMBER |
LINE_NUMBER |
NAME |
SERVICE_START_DATE |
SERVICE_END_DATE |
OBJECT_VERSION_NUMBER |