VIEW: APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)