Posts

Showing posts with the label Oracle Tax

Getting the Tax Rate Codes by Business Unit and Reference Set

Use the Below QUERY to get the Tax Rate Codes corresponding to each Business Unit and Reference Data Set. SELECT A.INTERNAL_ORGANIZATION_ID,        BU.BU_NAME,        R.TAX_RATE_CODE,        RM.COUNTRY_CODE,        T.TAX_TYPE_CODE,        RM.TAX_REGIME_CODE,        RM.REGIME_TYPE_FLAG,        LC.LOOKUP_TYPE,        LC.LOOKUP_CODE,        LC.DISPLAY_SEQUENCE,        LC.ENABLED_FLAG,        LC.START_DATE_ACTIVE,        LC.END_DATE_ACTIVE,        LC.MEANING,        LC.DESCRIPTION,        LC.TAG,   ...