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_DEPENDENCIES_V

Product:	OKE - Project Contracts
Description:	View for deliverable dependencies
Implementation/DBA Data:	APPS.OKE_DEPENDENCIES_V

View Text

SELECT D.ROWID
, D.DELIVERABLE_ID
, PD.DELIVERABLE_NUM
, PD.COMPLETED_FLAG
, PL.ID
, PL.LINE_NUMBER
, D.DEPENDENT_ID
, SD.DELIVERABLE_NUM
, SL.ID
, SL.LINE_NUMBER
, D.DESCRIPTION
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
FROM OKE_DEPENDENCIES D
, OKE_K_DELIVERABLES_B SD
, OKE_K_DELIVERABLES_B PD
, OKC_K_LINES_B PL
, OKC_K_LINES_B SL
WHERE D.DELIVERABLE_ID = PD.DELIVERABLE_ID
AND D.DEPENDENT_ID = SD.DELIVERABLE_ID
AND PL.ID = PD.K_LINE_ID
AND SL.ID = SD.K_LINE_ID

Columns

Name
ROW_ID
DELIVERABLE_ID
DELIVERABLE_NUM
DELIVERABLE_COMPLETED_FLAG
DELIVERABLE_LINE_ID
DELIVERABLE_LINE_NUMBER
DEPENDENT_ID
DEPENDENT_NUM
DEPENDENT_LINE_ID
DEPENDENT_LINE_NUMBER
DESCRIPTION
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN