VIEW: APPS.OKE_DTS_SUBCONTRACTS_V

Source

View Text - Preformatted

SELECT D.K_HEADER_ID , D.K_LINE_ID , D.DELIVERABLE_ID , SKD.K_HEADER_ID , SKD.K_LINE_ID , SKD.DELIVERABLE_ID , SKH.K_NUMBER_DISP , SKL.LINE_NUMBER , SKD.DELIVERABLE_NUM , KT.K_TYPE_NAME , STS.MEANING , SKD.QUANTITY , SKD.DELIVERY_DATE , SKD.NEED_BY_DATE FROM OKE_K_DELIVERABLES_B D , OKE_K_DELIVERABLES_B SKD , OKE_K_LINES_V SKL , OKE_K_HEADERS_V SKH , OKE_K_TYPES_VL KT , OKC_STATUSES_V STS WHERE D.SUB_REF_ID = SKD.DELIVERABLE_ID AND SKL.K_LINE_ID = SKD.K_LINE_ID AND SKH.K_HEADER_ID = SKD.K_HEADER_ID AND KT.K_TYPE_CODE = SKH.K_TYPE_CODE AND STS.CODE = SKH.STATUS_CODE

View Text - HTML Formatted

SELECT D.K_HEADER_ID
, D.K_LINE_ID
, D.DELIVERABLE_ID
, SKD.K_HEADER_ID
, SKD.K_LINE_ID
, SKD.DELIVERABLE_ID
, SKH.K_NUMBER_DISP
, SKL.LINE_NUMBER
, SKD.DELIVERABLE_NUM
, KT.K_TYPE_NAME
, STS.MEANING
, SKD.QUANTITY
, SKD.DELIVERY_DATE
, SKD.NEED_BY_DATE
FROM OKE_K_DELIVERABLES_B D
, OKE_K_DELIVERABLES_B SKD
, OKE_K_LINES_V SKL
, OKE_K_HEADERS_V SKH
, OKE_K_TYPES_VL KT
, OKC_STATUSES_V STS
WHERE D.SUB_REF_ID = SKD.DELIVERABLE_ID
AND SKL.K_LINE_ID = SKD.K_LINE_ID
AND SKH.K_HEADER_ID = SKD.K_HEADER_ID
AND KT.K_TYPE_CODE = SKH.K_TYPE_CODE
AND STS.CODE = SKH.STATUS_CODE