eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKE_DTS_SUBCONTRACTS_V

Product:	OKE - Project Contracts
Description:	View for subcontract data related to contract deliverables
Implementation/DBA Data:	APPS.OKE_DTS_SUBCONTRACTS_V

View Text

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

Columns

Name
K_HEADER_ID
K_LINE_ID
DELIVERABLE_ID
SUBK_HEADER_ID
SUBK_LINE_ID
SUBK_DELIVERABLE_ID
SUBCONTRACT_NUMBER
SUBCONTRACT_LINE_NUMBER
SUBCONTRACT_DELIVERABLE_NUM
SUBCONTRACT_K_TYPE
SUBCONTRACT_STATUS
QUANTITY
DELIVERY_DATE
NEED_BY_DATE