VIEW: APPS.PQH_SPECIAL_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT sat_glb.context context , sat_glb.glb_context glb_context , sat_glb.glb_special_attribute_id glb_special_attribute_id , sat_glb.txn_category_attribute_id txn_category_attribute_id , sat_glb.attribute_type_cd attribute_type_cd , sat_glb.flex_code flex_code , sat_glb.ddf_column_name ddf_column_name , sat_glb.ddf_value_column_name ddf_value_column_name , sat_glb.enable enable , sat.special_attribute_id special_attribute_id , atl.attribute_name 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 , sat.enable_flag enable 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.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 (+)

View Text - HTML Formatted

SELECT SAT_GLB.CONTEXT CONTEXT
, SAT_GLB.GLB_CONTEXT GLB_CONTEXT
, SAT_GLB.GLB_SPECIAL_ATTRIBUTE_ID GLB_SPECIAL_ATTRIBUTE_ID
, SAT_GLB.TXN_CATEGORY_ATTRIBUTE_ID TXN_CATEGORY_ATTRIBUTE_ID
, SAT_GLB.ATTRIBUTE_TYPE_CD ATTRIBUTE_TYPE_CD
, SAT_GLB.FLEX_CODE FLEX_CODE
, SAT_GLB.DDF_COLUMN_NAME DDF_COLUMN_NAME
, SAT_GLB.DDF_VALUE_COLUMN_NAME DDF_VALUE_COLUMN_NAME
, SAT_GLB.ENABLE ENABLE
, SAT.SPECIAL_ATTRIBUTE_ID SPECIAL_ATTRIBUTE_ID
, ATL.ATTRIBUTE_NAME 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
, SAT.ENABLE_FLAG ENABLE
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.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 (+)