View: PQH_SPECIAL_ATTRIBUTES_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_SPECIAL_ATTRIBUTES_V

View Text

SELECT SAT_GLB.*
, SAT.SPECIAL_ATTRIBUTE_ID
, ATL.ATTRIBUTE_NAME
, TRL.DISPLAY_NAME TABLE_NAME
, CEC.TRANSACTION_SHORT_NAME
, CEC.APPLICATION_SHORT_NAME
, DECODE(SAT.SPECIAL_ATTRIBUTE_ID
, NULL
, 'NO'
, 'YES') ENABLE_FLAG
, SAT.OBJECT_VERSION_NUMBER
, SAT.CREATION_DATE
, SAT.CREATED_BY
, SAT.LAST_UPDATE_LOGIN
, SAT.LAST_UPDATED_BY
, SAT.LAST_UPDATE_DATE
FROM PQH_SPECIAL_ATTRIBUTES SAT
, PQH_COPY_ENTITY_CONTEXTS CEC
, PQH_ATTRIBUTES_VL ATL
, PQH_TABLE_ROUTE_VL TRL
, PQH_TXN_CATEGORY_ATTRIBUTES TCA
, ( SELECT CEC.CONTEXT
, SAT.CONTEXT GLB_CONTEXT
, SAT.SPECIAL_ATTRIBUTE_ID GLB_SPECIAL_ATTRIBUTE_ID
, SAT.TXN_CATEGORY_ATTRIBUTE_ID
, SAT.ATTRIBUTE_TYPE_CD
, SAT.FLEX_CODE
, SAT.DDF_COLUMN_NAME
, SAT.DDF_VALUE_COLUMN_NAME
FROM PQH_SPECIAL_ATTRIBUTES SAT
, PQH_COPY_ENTITY_CONTEXTS CEC
WHERE SAT.CONTEXT = PQH_CONTEXT.GET_GLOBAL_CONTEXT(CEC.CONTEXT)) SAT_GLB
WHERE CEC.CONTEXT = SAT_GLB.GLB_CONTEXT
AND SAT_GLB.CONTEXT = SAT.CONTEXT (+)
AND SAT_GLB.TXN_CATEGORY_ATTRIBUTE_ID = SAT.TXN_CATEGORY_ATTRIBUTE_ID (+)
AND SAT_GLB.ATTRIBUTE_TYPE_CD = SAT.ATTRIBUTE_TYPE_CD (+)
AND SAT_GLB.TXN_CATEGORY_ATTRIBUTE_ID = TCA.TXN_CATEGORY_ATTRIBUTE_ID
AND TCA.ATTRIBUTE_ID = ATL.ATTRIBUTE_ID
AND ATL.MASTER_TABLE_ROUTE_ID = TRL.TABLE_ROUTE_ID (+)

Columns