Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_COPY_ENTITY_CONTEXTS_V |
SELECT CEC.ROWID ROW_ID
, CEC.CONTEXT
, CEC.APPLICATION_SHORT_NAME
, CEC.LEGISLATION_CODE
, CEC.RESPONSIBILITY_KEY
, CEC.TRANSACTION_SHORT_NAME
, CEC.OBJECT_VERSION_NUMBER
, CEC.LAST_UPDATE_DATE
, CEC.CREATION_DATE
, CEC.CREATED_BY
, CEC.LAST_UPDATE_LOGIN
, CEC.LAST_UPDATED_BY
, APP.APPLICATION_NAME
, RES.RESPONSIBILITY_NAME RESPONSIBILITY
, TER.TERRITORY_SHORT_NAME LEGISLATION_DESC
, TCT.NAME TRANSACTION_NAME
FROM PQH_COPY_ENTITY_CONTEXTS CEC
, FND_APPLICATION_VL APP
, FND_RESPONSIBILITY_VL RES
, FND_TERRITORIES_VL TER
, PQH_TRANSACTION_CATEGORIES_VL TCT
WHERE CEC.RESPONSIBILITY_KEY = RES.RESPONSIBILITY_KEY (+)
AND CEC.APPLICATION_SHORT_NAME = APP.APPLICATION_SHORT_NAME (+)
AND CEC.LEGISLATION_CODE = TER.TERRITORY_CODE (+)
AND CEC.TRANSACTION_SHORT_NAME = TCT.SHORT_NAME