VIEW: APPS.PQH_TEMPLATE_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT tat.TEMPLATE_ATTRIBUTE_ID , tat.TEMPLATE_ID , tat.ATTRIBUTE_ID , att.ATTRIBUTE_NAME , tat.VIEW_FLAG , tat.EDIT_FLAG , tat.REQUIRED_FLAG , att.COLUMN_TYPE , tct.SELECT_FLAG, att.legislation_code, tat.LAST_UPDATE_DATE , tat.LAST_UPDATED_BY , tat.LAST_UPDATE_LOGIN, tat.CREATED_BY , tat.CREATION_DATE , tat.OBJECT_VERSION_NUMBER from pqh_template_attributes tat,pqh_attributes_vl att, pqh_txn_category_attributes tct, pqh_templates ttt WHERE tat.attribute_id = att.attribute_id and tct.attribute_id = att.attribute_id and ttt.template_id = tat.template_id and tct.transaction_category_id = ttt.transaction_category_id

View Text - HTML Formatted

SELECT TAT.TEMPLATE_ATTRIBUTE_ID
, TAT.TEMPLATE_ID
, TAT.ATTRIBUTE_ID
, ATT.ATTRIBUTE_NAME
, TAT.VIEW_FLAG
, TAT.EDIT_FLAG
, TAT.REQUIRED_FLAG
, ATT.COLUMN_TYPE
, TCT.SELECT_FLAG
, ATT.LEGISLATION_CODE
, TAT.LAST_UPDATE_DATE
, TAT.LAST_UPDATED_BY
, TAT.LAST_UPDATE_LOGIN
, TAT.CREATED_BY
, TAT.CREATION_DATE
, TAT.OBJECT_VERSION_NUMBER
FROM PQH_TEMPLATE_ATTRIBUTES TAT
, PQH_ATTRIBUTES_VL ATT
, PQH_TXN_CATEGORY_ATTRIBUTES TCT
, PQH_TEMPLATES TTT
WHERE TAT.ATTRIBUTE_ID = ATT.ATTRIBUTE_ID
AND TCT.ATTRIBUTE_ID = ATT.ATTRIBUTE_ID
AND TTT.TEMPLATE_ID = TAT.TEMPLATE_ID
AND TCT.TRANSACTION_CATEGORY_ID = TTT.TRANSACTION_CATEGORY_ID