VIEW: APPS.PQH_TEMPLATES_V

Source

View Text - Preformatted

SELECT tem.row_id, tem.TEMPLATE_NAME , tem.short_name, tem.TEMPLATE_ID , tem.ATTRIBUTE_ONLY_FLAG , tem.ENABLE_FLAG , tem.CREATE_FLAG , lkp.meaning template_task_type, tem.TRANSACTION_CATEGORY_ID , tct.name transaction_category_name, tem.UNDER_REVIEW_FLAG , tem.freeze_status_cd , c.meaning freeze_status, tem.template_type_cd, l.meaning template_type, leg.territory_code, leg.territory_short_name, tem.OBJECT_VERSION_NUMBER , tem.LAST_UPDATE_DATE , tem.LAST_UPDATED_BY , tem.LAST_UPDATE_LOGIN , tem.CREATED_BY , tem.CREATION_DATE FROM pqh_templates_vl tem,pqh_transaction_categories_vl tct, fnd_territories_vl leg, hr_lookups c , hr_lookups l ,hr_lookups lkp WHERE tem.transaction_category_id = tct.transaction_category_id AND tem.legislation_code = leg.territory_code (+) AND tem.freeze_status_cd = c.lookup_code(+) AND c.lookup_type(+) = 'PQH_TEMPLATE_FREEZE_STATUS' AND tem.template_type_cd = l.lookup_code AND l.lookup_type = 'PQH_TEMPLATE_TYPE' AND tem.create_flag = lkp.lookup_code(+) AND lkp.lookup_type(+) = 'PQH_TEMPLATE_TASK_TYPE'

View Text - HTML Formatted

SELECT TEM.ROW_ID
, TEM.TEMPLATE_NAME
, TEM.SHORT_NAME
, TEM.TEMPLATE_ID
, TEM.ATTRIBUTE_ONLY_FLAG
, TEM.ENABLE_FLAG
, TEM.CREATE_FLAG
, LKP.MEANING TEMPLATE_TASK_TYPE
, TEM.TRANSACTION_CATEGORY_ID
, TCT.NAME TRANSACTION_CATEGORY_NAME
, TEM.UNDER_REVIEW_FLAG
, TEM.FREEZE_STATUS_CD
, C.MEANING FREEZE_STATUS
, TEM.TEMPLATE_TYPE_CD
, L.MEANING TEMPLATE_TYPE
, LEG.TERRITORY_CODE
, LEG.TERRITORY_SHORT_NAME
, TEM.OBJECT_VERSION_NUMBER
, TEM.LAST_UPDATE_DATE
, TEM.LAST_UPDATED_BY
, TEM.LAST_UPDATE_LOGIN
, TEM.CREATED_BY
, TEM.CREATION_DATE
FROM PQH_TEMPLATES_VL TEM
, PQH_TRANSACTION_CATEGORIES_VL TCT
, FND_TERRITORIES_VL LEG
, HR_LOOKUPS C
, HR_LOOKUPS L
, HR_LOOKUPS LKP
WHERE TEM.TRANSACTION_CATEGORY_ID = TCT.TRANSACTION_CATEGORY_ID
AND TEM.LEGISLATION_CODE = LEG.TERRITORY_CODE (+)
AND TEM.FREEZE_STATUS_CD = C.LOOKUP_CODE(+)
AND C.LOOKUP_TYPE(+) = 'PQH_TEMPLATE_FREEZE_STATUS'
AND TEM.TEMPLATE_TYPE_CD = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'PQH_TEMPLATE_TYPE'
AND TEM.CREATE_FLAG = LKP.LOOKUP_CODE(+)
AND LKP.LOOKUP_TYPE(+) = 'PQH_TEMPLATE_TASK_TYPE'