Product: | PQH - Public Sector HR |
---|---|
Description: | Transaction category attributes View |
Implementation/DBA Data: | APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V |
SELECT TCA.TXN_CATEGORY_ATTRIBUTE_ID
, TCA.ATTRIBUTE_ID
, ATT.ATTRIBUTE_NAME
, ATT.MASTER_ATTRIBUTE_ID
, TCA.TRANSACTION_CATEGORY_ID
, TCA.VALUE_SET_ID
, TCA.TRANSACTION_TABLE_ROUTE_ID
, TCA.FORM_COLUMN_NAME
, TCA.IDENTIFIER_FLAG
, TCA.LIST_IDENTIFYING_FLAG
, TCA.MEMBER_IDENTIFYING_FLAG
, TCA.REFRESH_FLAG
, TCA.VALUE_STYLE_CD
, LKP.MEANING VALUE_STYLE_MEANING
, TCA.SELECT_FLAG
, TCA.CREATED_BY
, TCA.CREATION_DATE
, TCA.LAST_UPDATED_BY
, TCA.LAST_UPDATE_DATE
, TCA.LAST_UPDATE_LOGIN
, TCA.OBJECT_VERSION_NUMBER
FROM PQH_ATTRIBUTES_VL ATT
, PQH_TXN_CATEGORY_ATTRIBUTES TCA
, HR_LOOKUPS LKP
WHERE ATT.ATTRIBUTE_ID = TCA.ATTRIBUTE_ID
AND LKP.LOOKUP_TYPE(+) = 'PQH_VALUE_STYLE'
AND TCA.VALUE_STYLE_CD = LKP.LOOKUP_CODE(+)