[Home] [Help]
View: ZX_ACCOUNT_RATES_V
View Text
SELECT ZXAR.LEDGER_ID
,
LGR.NAME LEDGER_NAME
,
ZXAR.TAX_CURRENCY_CODE
,
ZXAR.TAX_PRECISION
,
ZXAR.TAX_MAU
,
ZXAR.CALCULATION_LEVEL_CODE
,
ZXAR.ALLOW_ROUNDING_OVERRIDE_FLAG
,
ZXAR.RECORD_TYPE_CODE
,
ZXAR.TAX_CLASS
,
ZXAR.TAX_REGIME_CODE
,
ZXAR.CONTENT_OWNER_ID
,
PTP.PARTY_NAME CONTENT_OWNER_NAME
,
ZXAR.TAX
,
ZXAR.TAX_STATUS_CODE
,
ZXAR.TAX_RATE_CODE
,
ZXAR.ROUNDING_RULE_CODE
,
ZXAR.AMT_INCL_TAX_FLAG
,
ZXAR.CREATION_DATE
, ZXAR.CREATED_BY
, ZXAR.LAST_UPDATE_DATE
, ZXAR.LAST_UPDATED_BY
, ZXAR.LAST_UPDATE_LOGIN
,
ZXAR.ATTRIBUTE_CATEGORY
,
ZXAR.ATTRIBUTE1
, ZXAR.ATTRIBUTE2
, ZXAR.ATTRIBUTE3
, ZXAR.ATTRIBUTE4
, ZXAR.ATTRIBUTE5
,
ZXAR.ATTRIBUTE6
, ZXAR.ATTRIBUTE7
, ZXAR.ATTRIBUTE8
, ZXAR.ATTRIBUTE9
, ZXAR.ATTRIBUTE10
,
ZXAR.ATTRIBUTE11
, ZXAR.ATTRIBUTE12
, ZXAR.ATTRIBUTE13
, ZXAR.ATTRIBUTE14
, ZXAR.ATTRIBUTE15
,
ACCOUNT_SEGMENT_VALUE
FROM ZX_ACCOUNT_RATES ZXAR
, GL_LEDGERS LGR
, ZX_FIRST_PARTY_ORGS_ALL_V PTP
WHERE LGR.LEDGER_ID = ZXAR.LEDGER_ID
AND ACCOUNT_SEGMENT_VALUE IS NULL
AND ZXAR.CONTENT_OWNER_ID = PTP.PARTY_TAX_PROFILE_ID