View: OKE_APPROVAL_PATHS_V

Product:	OKE - Project Contracts
Description:
Implementation/DBA Data:	APPS.OKE_APPROVAL_PATHS_V

View Text

SELECT B.ROWID
, B.APPROVAL_PATH_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.RECORD_VERSION_NUMBER
, T.NAME
, T.DESCRIPTION
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SIGNATURE_REQUIRED_FLAG
, B.SIGNATORY_ROLE_ID
, R.MEANING
FROM OKE_APPROVAL_PATHS B
, OKE_APPROVAL_PATHS_TL T
, PA_PROJECT_ROLE_TYPES R
WHERE T.APPROVAL_PATH_ID = B.APPROVAL_PATH_ID
AND T.LANGUAGE = USERENV('LANG')
AND R.PROJECT_ROLE_ID (+) = B.SIGNATORY_ROLE_ID

Columns