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
AND zxar.ROWID IN (SELECT Min(zxar.ROWID)
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
GROUP BY zxar.ledger_id)
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
AND ZXAR.ROWID IN (SELECT MIN(ZXAR.ROWID)
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
GROUP BY ZXAR.LEDGER_ID)
|
|
|