VIEW: APPS.OKE_ORG_REL_ENTITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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