VIEW: APPS.GL_TAX_OPTIONS_V

Source

View Text - Preformatted

SELECT GTO.LEDGER_ID, LGR.NAME LEDGER_NAME, GTO.ORG_ID, GTO.TAX_CURRENCY_CODE, GTO.TAX_PRECISION, GTO.TAX_MAU, GTO.CALCULATION_LEVEL_CODE, GTO.ALLOW_ROUNDING_OVERRIDE_FLAG, GTO.INPUT_ROUNDING_RULE_CODE, GTO.OUTPUT_ROUNDING_RULE_CODE, GTO.CREATION_DATE, GTO.CREATED_BY, GTO.LAST_UPDATE_DATE, GTO.LAST_UPDATED_BY, GTO.LAST_UPDATE_LOGIN, GTO.INPUT_TAX_CODE, GTO.INPUT_AMT_INCL_TAX_FLAG, GTO.OUTPUT_TAX_CODE, GTO.OUTPUT_AMT_INCL_TAX_FLAG, GTO.CONTEXT, GTO.ATTRIBUTE1, GTO.ATTRIBUTE2, GTO.ATTRIBUTE3, GTO.ATTRIBUTE4, GTO.ATTRIBUTE5, GTO.ATTRIBUTE6, GTO.ATTRIBUTE7, GTO.ATTRIBUTE8, GTO.ATTRIBUTE9, GTO.ATTRIBUTE10, GTO.ATTRIBUTE11, GTO.ATTRIBUTE12, GTO.ATTRIBUTE13, GTO.ATTRIBUTE14, GTO.ATTRIBUTE15 FROM GL_TAX_OPTIONS GTO, GL_LEDGERS LGR WHERE LGR.LEDGER_ID = GTO.LEDGER_ID

View Text - HTML Formatted

SELECT GTO.LEDGER_ID
, LGR.NAME LEDGER_NAME
, GTO.ORG_ID
, GTO.TAX_CURRENCY_CODE
, GTO.TAX_PRECISION
, GTO.TAX_MAU
, GTO.CALCULATION_LEVEL_CODE
, GTO.ALLOW_ROUNDING_OVERRIDE_FLAG
, GTO.INPUT_ROUNDING_RULE_CODE
, GTO.OUTPUT_ROUNDING_RULE_CODE
, GTO.CREATION_DATE
, GTO.CREATED_BY
, GTO.LAST_UPDATE_DATE
, GTO.LAST_UPDATED_BY
, GTO.LAST_UPDATE_LOGIN
, GTO.INPUT_TAX_CODE
, GTO.INPUT_AMT_INCL_TAX_FLAG
, GTO.OUTPUT_TAX_CODE
, GTO.OUTPUT_AMT_INCL_TAX_FLAG
, GTO.CONTEXT
, GTO.ATTRIBUTE1
, GTO.ATTRIBUTE2
, GTO.ATTRIBUTE3
, GTO.ATTRIBUTE4
, GTO.ATTRIBUTE5
, GTO.ATTRIBUTE6
, GTO.ATTRIBUTE7
, GTO.ATTRIBUTE8
, GTO.ATTRIBUTE9
, GTO.ATTRIBUTE10
, GTO.ATTRIBUTE11
, GTO.ATTRIBUTE12
, GTO.ATTRIBUTE13
, GTO.ATTRIBUTE14
, GTO.ATTRIBUTE15
FROM GL_TAX_OPTIONS GTO
, GL_LEDGERS LGR
WHERE LGR.LEDGER_ID = GTO.LEDGER_ID