VIEW: APPS.PQH_TRANSACTION_CATEGORIES_V

Source

View Text - Preformatted

SELECT CTL.ROW_ID row_id, CTL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CTL.MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID, CTL.CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME, CTL.FORM_NAME FORM_NAME, CTL.FREEZE_STATUS_CD FREEZE_STATUS_CD, b.meaning FREEZE_STATUS_MEANING, CTL.MEMBER_CD MEMBER_CD, c.meaning MEMBER_MEANING , CTL.POST_STYLE_CD POST_STYLE_CD, d.meaning POST_STYLE_MEANING, CTL.FUTURE_ACTION_CD FUTURE_ACTION_CD, e.meaning FUTURE_ACTION_MEANING, CTL.POST_TXN_FUNCTION POST_TXN_FUNCTION, CTL.ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG, CTL.TIMEOUT_DAYS TIMEOUT_DAYS, CTL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CTL.TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID, CTL.CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID, TRT.FROM_CLAUSE FROM_CLAUSE, CTL.CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME, CTL.LAST_UPDATE_DATE LAST_UPDATE_DATE, CTL.CREATION_DATE CREATION_DATE, CTL.CREATED_BY CREATED_BY, CTL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CTL.LAST_UPDATED_BY LAST_UPDATED_BY, CTL.NAME NAME, CTL.SHORT_NAME SHORT_NAME, CTL.SETUP_TYPE_CD SETUP_TYPE_CD, f.meaning setup_type, CTL.ENABLE_FLAG ENABLE_FLAG, CTL.WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG, CTL.prevent_approver_skip prevent_approver_skip FROM pqh_transaction_categories_vl CTL , pqh_table_route TRT , hr_lookups b, hr_lookups c, hr_lookups d , hr_lookups e,hr_lookups f WHERE CTL.consolidated_table_route_id = TRT.table_route_id AND CTL.freeze_status_cd = b.lookup_code(+) AND b.lookup_type(+) = 'PQH_CATEGORY_FREEZE_STATUS' AND CTL.member_cd = c.lookup_code(+) AND c.lookup_type(+) = 'PQH_MEMBER_CD' AND CTL.post_style_cd = d.lookup_code(+) AND d.lookup_type(+) = 'PQH_POST_STYLE' AND CTL.future_Action_cd = e.lookup_code(+) AND e.lookup_type(+) = 'PQH_FUTURE_ACTION' AND CTL.setup_type_cd = f.lookup_code(+) AND f.lookup_type(+) = 'PQH_TXN_CAT_SETUP_TYPE'

View Text - HTML Formatted

SELECT CTL.ROW_ID ROW_ID
, CTL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CTL.MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID
, CTL.CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME
, CTL.FORM_NAME FORM_NAME
, CTL.FREEZE_STATUS_CD FREEZE_STATUS_CD
, B.MEANING FREEZE_STATUS_MEANING
, CTL.MEMBER_CD MEMBER_CD
, C.MEANING MEMBER_MEANING
, CTL.POST_STYLE_CD POST_STYLE_CD
, D.MEANING POST_STYLE_MEANING
, CTL.FUTURE_ACTION_CD FUTURE_ACTION_CD
, E.MEANING FUTURE_ACTION_MEANING
, CTL.POST_TXN_FUNCTION POST_TXN_FUNCTION
, CTL.ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG
, CTL.TIMEOUT_DAYS TIMEOUT_DAYS
, CTL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CTL.TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, CTL.CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID
, TRT.FROM_CLAUSE FROM_CLAUSE
, CTL.CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME
, CTL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CTL.CREATION_DATE CREATION_DATE
, CTL.CREATED_BY CREATED_BY
, CTL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CTL.LAST_UPDATED_BY LAST_UPDATED_BY
, CTL.NAME NAME
, CTL.SHORT_NAME SHORT_NAME
, CTL.SETUP_TYPE_CD SETUP_TYPE_CD
, F.MEANING SETUP_TYPE
, CTL.ENABLE_FLAG ENABLE_FLAG
, CTL.WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG
, CTL.PREVENT_APPROVER_SKIP PREVENT_APPROVER_SKIP
FROM PQH_TRANSACTION_CATEGORIES_VL CTL
, PQH_TABLE_ROUTE TRT
, HR_LOOKUPS B
, HR_LOOKUPS C
, HR_LOOKUPS D
, HR_LOOKUPS E
, HR_LOOKUPS F
WHERE CTL.CONSOLIDATED_TABLE_ROUTE_ID = TRT.TABLE_ROUTE_ID
AND CTL.FREEZE_STATUS_CD = B.LOOKUP_CODE(+)
AND B.LOOKUP_TYPE(+) = 'PQH_CATEGORY_FREEZE_STATUS'
AND CTL.MEMBER_CD = C.LOOKUP_CODE(+)
AND C.LOOKUP_TYPE(+) = 'PQH_MEMBER_CD'
AND CTL.POST_STYLE_CD = D.LOOKUP_CODE(+)
AND D.LOOKUP_TYPE(+) = 'PQH_POST_STYLE'
AND CTL.FUTURE_ACTION_CD = E.LOOKUP_CODE(+)
AND E.LOOKUP_TYPE(+) = 'PQH_FUTURE_ACTION'
AND CTL.SETUP_TYPE_CD = F.LOOKUP_CODE(+)
AND F.LOOKUP_TYPE(+) = 'PQH_TXN_CAT_SETUP_TYPE'