Product: | OKE - Project Contracts |
---|---|
Description: | View for deliverable dependencies |
Implementation/DBA Data: | APPS.OKE_DEPENDENCIES_V |
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