VIEW: APPS.PQH_COPY_ENTITY_CONTEXTS_V

Source

View Text - Preformatted

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 and cec.transaction_short_name not in ('PQHGSP', 'PURGE') and tct.business_group_id is null

View Text - HTML Formatted

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
AND CEC.TRANSACTION_SHORT_NAME NOT IN ('PQHGSP'
, 'PURGE')
AND TCT.BUSINESS_GROUP_ID IS NULL