VIEW: APPS.AST_PARTY_CLASSIFICATION_V

Source

View Text - Preformatted

SELECT cod.code_assignment_id , cod.owner_table_name , cod.owner_table_id , cod.class_category, type.description , cod.class_code, lkup.meaning , cod.primary_flag , cod.importance_ranking , cod.start_date_active , cod.end_date_active , cod.status, cod.created_by, cod.creation_date, cod.last_update_login, cod.last_update_date, cod.last_updated_by, cod.object_version_number, cod.created_by_module, cod.application_id, cod.RANK from hz_code_assignments cod, hz_class_categories cat, ar_lookup_types type, ar_lookups lkup WHERE cod.class_category = cat.class_category and cod.owner_table_name = 'HZ_PARTIES' and cod.class_code = lkup.lookup_code and cod.class_category = lkup.lookup_type and cod.class_category = type.lookup_type (+)

View Text - HTML Formatted

SELECT COD.CODE_ASSIGNMENT_ID
, COD.OWNER_TABLE_NAME
, COD.OWNER_TABLE_ID
, COD.CLASS_CATEGORY
, TYPE.DESCRIPTION
, COD.CLASS_CODE
, LKUP.MEANING
, COD.PRIMARY_FLAG
, COD.IMPORTANCE_RANKING
, COD.START_DATE_ACTIVE
, COD.END_DATE_ACTIVE
, COD.STATUS
, COD.CREATED_BY
, COD.CREATION_DATE
, COD.LAST_UPDATE_LOGIN
, COD.LAST_UPDATE_DATE
, COD.LAST_UPDATED_BY
, COD.OBJECT_VERSION_NUMBER
, COD.CREATED_BY_MODULE
, COD.APPLICATION_ID
, COD.RANK
FROM HZ_CODE_ASSIGNMENTS COD
, HZ_CLASS_CATEGORIES CAT
, AR_LOOKUP_TYPES TYPE
, AR_LOOKUPS LKUP
WHERE COD.CLASS_CATEGORY = CAT.CLASS_CATEGORY
AND COD.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND COD.CLASS_CODE = LKUP.LOOKUP_CODE
AND COD.CLASS_CATEGORY = LKUP.LOOKUP_TYPE
AND COD.CLASS_CATEGORY = TYPE.LOOKUP_TYPE (+)