VIEW: APPS.AR_FEDERAL_CODE_ASSIG_V

Source

View Text - Preformatted

SELECT ca.rowid row_id, ca.code_assignment_id, ca.owner_table_name, ca.owner_table_id, p.party_name, p.party_type, p.status, ca.class_category, ca.class_code, lo.meaning, ca.primary_flag, ca.content_source_type, ca.start_date_active, ca.end_date_active, ca.status, ca.rank, ca.object_version_number, ca.created_by, ca.creation_date, ca.last_update_date, ca.last_updated_by FROM hz_code_assignments ca, ar_lookups lo, hz_parties p WHERE ca.class_category = 'US_FEDERAL_GOVT' AND ca.owner_table_name = 'HZ_PARTIES' AND ca.class_code = 'IRS_1099_RECEIVABLES' AND ca.class_category = lo.lookup_type AND ca.class_code = lo.lookup_code AND ca.owner_table_id = p.party_id AND ca.content_source_type = 'USER_ENTERED' AND p.party_type IN ('ORGANIZATION','PERSON') ORDER BY ca.start_date_active DESC

View Text - HTML Formatted

SELECT CA.ROWID ROW_ID
, CA.CODE_ASSIGNMENT_ID
, CA.OWNER_TABLE_NAME
, CA.OWNER_TABLE_ID
, P.PARTY_NAME
, P.PARTY_TYPE
, P.STATUS
, CA.CLASS_CATEGORY
, CA.CLASS_CODE
, LO.MEANING
, CA.PRIMARY_FLAG
, CA.CONTENT_SOURCE_TYPE
, CA.START_DATE_ACTIVE
, CA.END_DATE_ACTIVE
, CA.STATUS
, CA.RANK
, CA.OBJECT_VERSION_NUMBER
, CA.CREATED_BY
, CA.CREATION_DATE
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
FROM HZ_CODE_ASSIGNMENTS CA
, AR_LOOKUPS LO
, HZ_PARTIES P
WHERE CA.CLASS_CATEGORY = 'US_FEDERAL_GOVT'
AND CA.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CA.CLASS_CODE = 'IRS_1099_RECEIVABLES'
AND CA.CLASS_CATEGORY = LO.LOOKUP_TYPE
AND CA.CLASS_CODE = LO.LOOKUP_CODE
AND CA.OWNER_TABLE_ID = P.PARTY_ID
AND CA.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND P.PARTY_TYPE IN ('ORGANIZATION'
, 'PERSON') ORDER BY CA.START_DATE_ACTIVE DESC