ZX_TRADE_RECEIPTS_LINES

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 TRX_CURRENCY_CODE TAX_CURRENCY_CODE UNIT_OF_MEASURE 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

TRX_CURRENCY_CODE

TAX_CURRENCY_CODE

UNIT_OF_MEASURE

ATTRIBUTE10

Query

SQL_Statement
SELECT ZRND.APPLICATION_ID APPLICATION_ID, ZRND.EVENT_CLASS_CODE EVENT_CLASS_CODE, ZRND.ENTITY_CODE ENTITY_CODE, ZRND.TRX_ID TRX_ID, ZRND.TRX_LEVEL_TYPE TRX_LEVEL_TYPE, ZRND.TRX_LINE_ID TRX_LINE_ID, ZRND.REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID, ZRND.TAX_REGIME_ID TAX_REGIME_ID, ZRND.TAX_REGIME_CODE TAX_REGIME_CODE, ZRND.TAX_ID TAX_ID, ZRND.TAX TAX, ZRND.TAX_STATUS_ID TAX_STATUS_ID, ZRND.TAX_STATUS_CODE TAX_STATUS_CODE, ZRND.TAX_RATE_ID TAX_RATE_ID, ZRND.TAX_RATE_CODE TAX_RATE_CODE, ZRND.RECOVERABLE_FLAG RECOVERABLE_FLAG, ZRND.RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE, ZRND.REC_NREC_TAX_AMT REC_NREC_TAX_AMT, ZRND.ACCOUNT_CCID REC_NREC_CCID, NVL((SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = ZRND.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id = ZRND.internal_organization_id AND acct.ledger_id = ZRND.ledger_id), (SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = ZRND.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id IS NULL AND acct.ledger_id = ZRND.ledger_id)) TAX_LIABILITY_CCID, ZRND.SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, ZRND.REPORTABLE_FLAG REPORTABLE_FLAG, ZRND.INCLUSIVE_FLAG INCLUSIVE_FLAG, ZRND.TRX_LINE_DIST_ID, ZRND.REVERSED_TAX_DIST_ID, ZRND.REVERSE_FLAG, ZRND.REF_DOC_PER_UNIT_NREC_TAX_AMT, ZRND.RECOVERY_RATE_CODE, ZRND.TAX_JURISDICTION_ID, ZRND.TAX_POINT_BASIS, ZRND.TAX_RATE, ZRND.TRX_LINE_DIST_AMT, ZRND.TRX_LINE_DIST_QTY, ZRND.TRX_CURRENCY_CODE, ZRND.TAX_CURRENCY_CODE, ZLDF.UOM_CODE UNIT_OF_MEASURE, ZRND.ATTRIBUTE10 ATTRIBUTE10 FROM ZX_REC_NREC_DIST ZRND,ZX_LINES_DET_FACTORS ZLDF WHERE ZRND.APPLICATION_ID=ZLDF.APPLICATION_ID AND ZRND.ENTITY_CODE=ZLDF.ENTITY_CODE AND ZRND.EVENT_CLASS_CODE=ZLDF.EVENT_CLASS_CODE AND ZRND.TRX_ID=ZLDF.TRX_ID AND ZRND.TRX_LINE_ID=ZLDF.TRX_LINE_ID AND ZRND.TRX_LEVEL_TYPE=ZLDF.TRX_LEVEL_TYPE

SQL_Statement

SELECT

ZRND.APPLICATION_ID APPLICATION_ID,

ZRND.EVENT_CLASS_CODE EVENT_CLASS_CODE,

ZRND.ENTITY_CODE ENTITY_CODE,

ZRND.TRX_ID TRX_ID,

ZRND.TRX_LEVEL_TYPE TRX_LEVEL_TYPE,

ZRND.TRX_LINE_ID TRX_LINE_ID,

ZRND.REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID,

ZRND.TAX_REGIME_ID TAX_REGIME_ID,

ZRND.TAX_REGIME_CODE TAX_REGIME_CODE,

ZRND.TAX_ID TAX_ID,

ZRND.TAX TAX,

ZRND.TAX_STATUS_ID TAX_STATUS_ID,

ZRND.TAX_STATUS_CODE TAX_STATUS_CODE,

ZRND.TAX_RATE_ID TAX_RATE_ID,

ZRND.TAX_RATE_CODE TAX_RATE_CODE,

ZRND.RECOVERABLE_FLAG RECOVERABLE_FLAG,

ZRND.RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE,

ZRND.REC_NREC_TAX_AMT REC_NREC_TAX_AMT,

ZRND.ACCOUNT_CCID REC_NREC_CCID,

NVL((SELECT tax_liab_acct_ccid

FROM zx_accounts acct

WHERE acct.tax_account_entity_id = ZRND.tax_rate_id

AND acct.tax_account_entity_code = 'RATES'

AND acct.internal_organization_id = ZRND.internal_organization_id

AND acct.ledger_id = ZRND.ledger_id),

(SELECT tax_liab_acct_ccid

FROM zx_accounts acct

WHERE acct.tax_account_entity_id = ZRND.tax_rate_id

AND acct.tax_account_entity_code = 'RATES'

AND acct.internal_organization_id IS NULL

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

ZRND.SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG,

ZRND.REPORTABLE_FLAG REPORTABLE_FLAG,

ZRND.INCLUSIVE_FLAG INCLUSIVE_FLAG,

ZRND.TRX_LINE_DIST_ID,

ZRND.REVERSED_TAX_DIST_ID,

ZRND.REVERSE_FLAG,

ZRND.REF_DOC_PER_UNIT_NREC_TAX_AMT,

ZRND.RECOVERY_RATE_CODE,

ZRND.TAX_JURISDICTION_ID,

ZRND.TAX_POINT_BASIS,

ZRND.TAX_RATE,

ZRND.TRX_LINE_DIST_AMT,

ZRND.TRX_LINE_DIST_QTY,

ZRND.TRX_CURRENCY_CODE,

ZRND.TAX_CURRENCY_CODE,

ZLDF.UOM_CODE UNIT_OF_MEASURE,

ZRND.ATTRIBUTE10 ATTRIBUTE10

FROM ZX_REC_NREC_DIST ZRND,ZX_LINES_DET_FACTORS ZLDF

WHERE ZRND.APPLICATION_ID=ZLDF.APPLICATION_ID

AND ZRND.ENTITY_CODE=ZLDF.ENTITY_CODE

AND ZRND.EVENT_CLASS_CODE=ZLDF.EVENT_CLASS_CODE

AND ZRND.TRX_ID=ZLDF.TRX_ID

AND ZRND.TRX_LINE_ID=ZLDF.TRX_LINE_ID

AND ZRND.TRX_LEVEL_TYPE=ZLDF.TRX_LEVEL_TYPE