ZX_INPUT_ACCOUNTS

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 REC_NREC_TAX_DIST_ID TAX_REGIME_ID TAX_REGIME_CODE TAX_ID TAX TAX_STATUS_ID TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE RECOVERABLE_FLAG RECOVERY_TYPE_CODE REC_NREC_TAX_AMT REC_NREC_CCID TAX_LIABILITY_CCID SELF_ASSESSED_FLAG REPORTABLE_FLAG INCLUSIVE_FLAG TRX_LINE_DIST_ID REVERSED_TAX_DIST_ID REVERSE_FLAG REF_DOC_PER_UNIT_NREC_TAX_AMT RECOVERY_RATE_CODE TAX_JURISDICTION_ID TAX_POINT_BASIS TAX_RATE TRX_LINE_DIST_AMT TRX_LINE_DIST_QTY ATTRIBUTE10

Name

APPLICATION_ID

EVENT_CLASS_CODE

ENTITY_CODE

TRX_ID

TRX_LEVEL_TYPE

TRX_LINE_ID

REC_NREC_TAX_DIST_ID

TAX_REGIME_ID

TAX_REGIME_CODE

TAX_ID

TAX

TAX_STATUS_ID

TAX_STATUS_CODE

TAX_RATE_ID

TAX_RATE_CODE

RECOVERABLE_FLAG

RECOVERY_TYPE_CODE

REC_NREC_TAX_AMT

REC_NREC_CCID

TAX_LIABILITY_CCID

SELF_ASSESSED_FLAG

REPORTABLE_FLAG

INCLUSIVE_FLAG

TRX_LINE_DIST_ID

REVERSED_TAX_DIST_ID

REVERSE_FLAG

REF_DOC_PER_UNIT_NREC_TAX_AMT

RECOVERY_RATE_CODE

TAX_JURISDICTION_ID

TAX_POINT_BASIS

TAX_RATE

TRX_LINE_DIST_AMT

TRX_LINE_DIST_QTY

ATTRIBUTE10

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, REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID, TAX_REGIME_ID TAX_REGIME_ID, TAX_REGIME_CODE TAX_REGIME_CODE, TAX_ID TAX_ID, TAX TAX, TAX_STATUS_ID TAX_STATUS_ID, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, RECOVERABLE_FLAG RECOVERABLE_FLAG, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE, REC_NREC_TAX_AMT REC_NREC_TAX_AMT, ACCOUNT_CCID REC_NREC_CCID, NVL((SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = dist.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id = dist.internal_organization_id AND acct.ledger_id = dist.ledger_id), (SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = dist.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id IS NULL AND acct.ledger_id = dist.ledger_id)) TAX_LIABILITY_CCID, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, REPORTABLE_FLAG REPORTABLE_FLAG, INCLUSIVE_FLAG INCLUSIVE_FLAG, TRX_LINE_DIST_ID, REVERSED_TAX_DIST_ID, REVERSE_FLAG, REF_DOC_PER_UNIT_NREC_TAX_AMT, RECOVERY_RATE_CODE, TAX_JURISDICTION_ID, TAX_POINT_BASIS, TAX_RATE, TRX_LINE_DIST_AMT, TRX_LINE_DIST_QTY, ATTRIBUTE10 FROM ZX_REC_NREC_DIST_GT DIST WHERE NVL(SELF_ASSESSED_FLAG, 'N') = 'N'

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,

REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID,

TAX_REGIME_ID TAX_REGIME_ID,

TAX_REGIME_CODE TAX_REGIME_CODE,

TAX_ID TAX_ID,

TAX TAX,

TAX_STATUS_ID TAX_STATUS_ID,

TAX_STATUS_CODE TAX_STATUS_CODE,

TAX_RATE_ID TAX_RATE_ID,

TAX_RATE_CODE TAX_RATE_CODE,

RECOVERABLE_FLAG RECOVERABLE_FLAG,

RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE,

REC_NREC_TAX_AMT REC_NREC_TAX_AMT,

ACCOUNT_CCID REC_NREC_CCID,

NVL((SELECT tax_liab_acct_ccid

FROM zx_accounts acct

WHERE acct.tax_account_entity_id = dist.tax_rate_id

AND acct.tax_account_entity_code = 'RATES'

AND acct.internal_organization_id = dist.internal_organization_id

AND acct.ledger_id = dist.ledger_id),

(SELECT tax_liab_acct_ccid

FROM zx_accounts acct

WHERE acct.tax_account_entity_id = dist.tax_rate_id

AND acct.tax_account_entity_code = 'RATES'

AND acct.internal_organization_id IS NULL

AND acct.ledger_id = dist.ledger_id)) TAX_LIABILITY_CCID,

SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG,

REPORTABLE_FLAG REPORTABLE_FLAG,

INCLUSIVE_FLAG INCLUSIVE_FLAG,

TRX_LINE_DIST_ID,

REVERSED_TAX_DIST_ID,

REVERSE_FLAG,

REF_DOC_PER_UNIT_NREC_TAX_AMT,

RECOVERY_RATE_CODE,

TAX_JURISDICTION_ID,

TAX_POINT_BASIS,

TAX_RATE,

TRX_LINE_DIST_AMT,

TRX_LINE_DIST_QTY,

ATTRIBUTE10

FROM

ZX_REC_NREC_DIST_GT DIST

WHERE

NVL(SELF_ASSESSED_FLAG, 'N') = 'N'