VIEW: APPS.ARFV_AR_TAX_CODES

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ RATES.TAX_RATE_ID TAX_CODE_ID, /* REGULAR ATTRIBUTES */ RATES.TAX_RATE_CODE TAX_CODE, REPCODEST.REPORTING_CODE_NAME TAX_NAME, RATES.EFFECTIVE_FROM START_EFFECTIVE_DATE, RATES.EFFECTIVE_TO END_EFFECTIVE_DATE, '_LA:TAXES.TAX_TYPE_CODE:FND_LOOKUPS:ZX_TAX_TYPE_CATEGORY:MEANING' "_LA:TAX_TYPE", RATES.PERCENTAGE_RATE TAX_RATE, '_LA:TAXES.ALLOW_EXEMPTIONS_FLAG:AR_LOOKUPS:YES/NO:MEANING' "_LA:ALLOW_EXEMPTION_FLAG", '_LA:RATES.INCLUSIVE_TAX_FLAG:AR_LOOKUPS:YES/NO:MEANING' "_LA:TAX_INCLUSIVE_FLAG", RATEST.TAX_RATE_NAME TAX_CODE_DESCRIPTION, /* RESOLVED FK RESOLUTIONS */ '_KF:SQLGL:GL#:GCC' "_KF:TAX_ACCOUNT_NAME", NULL TAX_GROUP_NAME, AOU.NAME OPERATING_UNIT, /* IDS */ ACCT.TAX_ACCOUNT_CCID TAX_ACCOUNT_ID, PTP.PARTY_ID ORG_ID, PTP.PARTY_TAX_PROFILE_ID CONTENT_OWNER_ID, /* WHO COLUMNS */ RATES.LAST_UPDATE_DATE LAST_UPDATE_DATE, RATES.LAST_UPDATED_BY LAST_UPDATED_BY, RATES.CREATION_DATE CREATION_DATE, RATES.CREATED_BY CREATED_BY FROM ZX_RATES_B RATES, ZX_RATES_TL RATEST, ZX_TAXES_B TAXES, ZX_ACCOUNTS ACCT, ZX_PARTY_TAX_PROFILE PTP, ZX_REPORTING_TYPES_B REPTYPES, ZX_REPORTING_CODES_B REPCODES, ZX_REPORTING_CODES_TL REPCODEST, ZX_REPORT_CODES_ASSOC REPASSOC, GL_CODE_COMBINATIONS GCC, HR_ALL_ORGANIZATION_UNITS AOU WHERE RATES.TAX_RATE_ID = RATEST.TAX_RATE_ID AND RATEST.LANGUAGE = USERENV('LANG') AND RATES.TAX_REGIME_CODE = TAXES.TAX_REGIME_CODE AND RATES.TAX = TAXES.TAX AND RATES.CONTENT_OWNER_ID = TAXES.CONTENT_OWNER_ID AND RATES.TAX_RATE_ID = ACCT.TAX_ACCOUNT_ENTITY_ID AND ACCT.TAX_ACCOUNT_ENTITY_CODE = 'RATES' AND PTP.PARTY_TAX_PROFILE_ID = RATES.CONTENT_OWNER_ID AND REPTYPES.REPORTING_TYPE_CODE = 'PRINTED_TAX_RATE_NAME' AND REPTYPES.REPORTING_TYPE_ID = REPCODES.REPORTING_TYPE_ID AND REPCODES.REPORTING_CODE_ID = REPCODEST.REPORTING_CODE_ID AND REPCODEST.LANGUAGE = USERENV('LANG') AND REPCODES.REPORTING_CODE_ID = REPASSOC.ENTITY_ID AND REPASSOC.ENTITY_CODE = 'ZX_RATES' AND ACCT.TAX_ACCOUNT_CCID = GCC.CODE_COMBINATION_ID(+) AND PTP.PARTY_ID = AOU.ORGANIZATION_ID AND '_SEC:PTP.PARTY_ID' IS NOT NULL AND RATES.SOURCE_ID IS NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ RATES.TAX_RATE_ID TAX_CODE_ID
, /* REGULAR ATTRIBUTES */ RATES.TAX_RATE_CODE TAX_CODE
, REPCODEST.REPORTING_CODE_NAME TAX_NAME
, RATES.EFFECTIVE_FROM START_EFFECTIVE_DATE
, RATES.EFFECTIVE_TO END_EFFECTIVE_DATE
, '_LA:TAXES.TAX_TYPE_CODE:FND_LOOKUPS:ZX_TAX_TYPE_CATEGORY:MEANING' "_LA:TAX_TYPE"
, RATES.PERCENTAGE_RATE TAX_RATE
, '_LA:TAXES.ALLOW_EXEMPTIONS_FLAG:AR_LOOKUPS:YES/NO:MEANING' "_LA:ALLOW_EXEMPTION_FLAG"
, '_LA:RATES.INCLUSIVE_TAX_FLAG:AR_LOOKUPS:YES/NO:MEANING' "_LA:TAX_INCLUSIVE_FLAG"
, RATEST.TAX_RATE_NAME TAX_CODE_DESCRIPTION
, /* RESOLVED FK RESOLUTIONS */ '_KF:SQLGL:GL#:GCC' "_KF:TAX_ACCOUNT_NAME"
, NULL TAX_GROUP_NAME
, AOU.NAME OPERATING_UNIT
, /* IDS */ ACCT.TAX_ACCOUNT_CCID TAX_ACCOUNT_ID
, PTP.PARTY_ID ORG_ID
, PTP.PARTY_TAX_PROFILE_ID CONTENT_OWNER_ID
, /* WHO COLUMNS */ RATES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RATES.LAST_UPDATED_BY LAST_UPDATED_BY
, RATES.CREATION_DATE CREATION_DATE
, RATES.CREATED_BY CREATED_BY
FROM ZX_RATES_B RATES
, ZX_RATES_TL RATEST
, ZX_TAXES_B TAXES
, ZX_ACCOUNTS ACCT
, ZX_PARTY_TAX_PROFILE PTP
, ZX_REPORTING_TYPES_B REPTYPES
, ZX_REPORTING_CODES_B REPCODES
, ZX_REPORTING_CODES_TL REPCODEST
, ZX_REPORT_CODES_ASSOC REPASSOC
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE RATES.TAX_RATE_ID = RATEST.TAX_RATE_ID
AND RATEST.LANGUAGE = USERENV('LANG')
AND RATES.TAX_REGIME_CODE = TAXES.TAX_REGIME_CODE
AND RATES.TAX = TAXES.TAX
AND RATES.CONTENT_OWNER_ID = TAXES.CONTENT_OWNER_ID
AND RATES.TAX_RATE_ID = ACCT.TAX_ACCOUNT_ENTITY_ID
AND ACCT.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
AND PTP.PARTY_TAX_PROFILE_ID = RATES.CONTENT_OWNER_ID
AND REPTYPES.REPORTING_TYPE_CODE = 'PRINTED_TAX_RATE_NAME'
AND REPTYPES.REPORTING_TYPE_ID = REPCODES.REPORTING_TYPE_ID
AND REPCODES.REPORTING_CODE_ID = REPCODEST.REPORTING_CODE_ID
AND REPCODEST.LANGUAGE = USERENV('LANG')
AND REPCODES.REPORTING_CODE_ID = REPASSOC.ENTITY_ID
AND REPASSOC.ENTITY_CODE = 'ZX_RATES'
AND ACCT.TAX_ACCOUNT_CCID = GCC.CODE_COMBINATION_ID(+)
AND PTP.PARTY_ID = AOU.ORGANIZATION_ID
AND '_SEC:PTP.PARTY_ID' IS NOT NULL
AND RATES.SOURCE_ID IS NULL WITH READ ONLY