View: OKE_ORG_REL_ENTITIES_V

Product:	OKE - Project Contracts
Description:	Related Documents View for Contract Organizer
Implementation/DBA Data:	APPS.OKE_ORG_REL_ENTITIES_V

View Text

SELECT S.ROWID
, S.K_HEADER_ID
, C.K_NUMBER_DISP
, R.CHG_REQUEST_ID
, R.CHG_REQUEST_NUM
, R.NEW_VERSION
, S.RELATED_ENTITY_ID
, F.K_TYPE_CODE
, KT.K_TYPE_NAME
, F.BUY_OR_SELL
, F.K_NUMBER_DISP
, TO_NUMBER(NULL)
, NULL
, S.RELATED_ENTITY_VERSION
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
FROM OKE_K_RELATED_ENTITIES S
, OKE_K_HEADERS C
, OKE_K_HEADERS_V F
, OKE_CHG_REQUESTS R
, OKE_K_TYPES_VL KT
WHERE C.K_HEADER_ID = S.K_HEADER_ID
AND F.K_HEADER_ID = S.RELATED_ENTITY_ID
AND R.CHG_REQUEST_ID (+) = S.CHG_REQUEST_ID
AND KT.K_TYPE_CODE = F.K_TYPE_CODE UNION ALL SELECT S.ROWID
, S.RELATED_ENTITY_ID
, C.K_NUMBER_DISP
, TO_NUMBER(NULL)
, NULL
, S.RELATED_ENTITY_VERSION
, S.K_HEADER_ID
, F.K_TYPE_CODE
, KT.K_TYPE_NAME
, F.BUY_OR_SELL
, F.K_NUMBER_DISP
, R.CHG_REQUEST_ID
, R.CHG_REQUEST_NUM
, TO_NUMBER(NULL)
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
FROM OKE_K_RELATED_ENTITIES S
, OKE_K_HEADERS C
, OKE_K_HEADERS_V F
, OKE_CHG_REQUESTS R
, OKE_K_TYPES_VL KT
WHERE C.K_HEADER_ID = S.RELATED_ENTITY_ID
AND F.K_HEADER_ID = S.K_HEADER_ID
AND R.CHG_REQUEST_ID (+) = S.CHG_REQUEST_ID
AND KT.K_TYPE_CODE = F.K_TYPE_CODE

Columns