eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ZX_ACCOUNT_RATES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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