[Home] [Help]
View: ARFV_AR_TAX_GROUPS
Product: | AR - Receivables |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* UNIQUE ATTRIBUTES */ VT.VAT_TAX_ID
, VT.TAX_CODE
, /* REGULAR ATTRIBUTES */ VT.PRINTED_TAX_NAME
, VT.DESCRIPTION
, VT.START_DATE
, VT.END_DATE
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, /* IDS */ VT.ORG_ID
, /* WHO COLUMNS */ VT.LAST_UPDATE_DATE
, VT.LAST_UPDATED_BY
, VT.CREATION_DATE
, VT.CREATED_BY
FROM AR_VAT_TAX_ALL_VL VT
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE VT.TAX_TYPE = 'TAX_GROUP'
AND VT.ORG_ID = AOU.ORGANIZATION_ID(+)
AND '_SEC:VT.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
TAX_GROUP_ID |
TAX_GROUP_CODE |
TAX_GROUP_NAME |
TAX_GROUP_DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
OPERATING_UNIT |
ORG_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |