1. Tables and Views for Financials
  2. ZX_OUTPUT_ACCOUNTS_V

ZX_OUTPUT_ACCOUNTS_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

APPLICATION_ID

EVENT_CLASS_CODE

ENTITY_CODE

TRX_ID

TRX_LEVEL_TYPE

TRX_LINE_ID

TAX_LINE_ID

TAX_REGIME_ID

TAX_ID

TAX

TAX_STATUS_ID

TAX_STATUS_CODE

TAX_JURISDICTION_CODE

TAX_RATE_ID

TAX_RATE_CODE

TAX_AMOUNT

TAX_LIAB_ACCT_CCID

TAX_ACCRUAL_ACCOUNT_CCID

REPORTABLE_FLAG

TAX_POINT_BASIS

TAX_AMT_INCLUDED_FLAG

Query

SQL_Statement

SELECT

APPLICATION_ID APPLICATION_ID,

event_class_code event_class_code,

entity_code ENTITY_CODE,

TRX_ID TRX_ID,

TRX_LEVEL_TYPE TRX_LEVEL_TYPE,

TRX_LINE_ID TRX_LINE_ID,

TAX_LINE_ID TAX_LINE_ID,

TAX_REGIME_ID TAX_REGIME_ID,

TAX_ID TAX_ID,

TAX TAX,

TAX_STATUS_ID TAX_STATUS_ID,

TAX_STATUS_CODE TAX_STATUS_CODE,

TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE,

TAX_RATE_ID TAX_RATE_ID,

TAX_RATE_CODE TAX_RATE_CODE,

TAX_AMT TAX_AMOUNT,

decode(tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID, NULL,

nvl( (select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

(select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID)

),

nvl( (select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

nvl( (select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

nvl((select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

(select TAX_LIAB_ACCT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID)

)

)

)

) TAX_LIAB_ACCT_CCID,

decode(tax_lines.reportable_flag, 'Y', decode(tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID, NULL,

nvl( (select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

(select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID)

),

nvl( (select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

nvl( (select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.ACCOUNT_SOURCE_TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

nvl((select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID = tax_lines.INTERNAL_ORGANIZATION_ID

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID),

(select TAX_ACCRUAL_ACCOUNT_CCID

from zx_accounts accounts

where accounts.TAX_ACCOUNT_ENTITY_ID = tax_lines.TAX_RATE_ID

AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

AND accounts.INTERNAL_ORGANIZATION_ID IS NULL

AND accounts.LEDGER_ID = tax_lines.LEDGER_ID)

)

)

)

) , NULL) TAX_ACCRUAL_ACCOUNT_CCID,

REPORTABLE_FLAG REPORTABLE_FLAG,

TAX_POINT_BASIS TAX_POINT_BASIS,

TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG

from zx_lines tax_lines