View: AR_FEDERAL_CODE_ASSIG_V

Product:	AR - Receivables
Description:	View used in Customer From for 1099 assignemnt
Implementation/DBA Data:	APPS.AR_FEDERAL_CODE_ASSIG_V

View Text

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

Columns