ZX_SHIPMENT_TAX_LINES_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID ENTITY_CODE EVEVT_CLASS_CODE TRX_ID TAX TAX_ID TAX_REGIME_CODE TAX_JURISDICTION_CODE TAX_RATE_CODE TAX_RATE TAX_AMT_INCLUDED_FLAG TAX_POINT_BASIS TAX_AMT TRX_LINE_ID TRX_LEVEL_TYPE TRX_CURRENCY_CODE TAX_LIABILITY_CCID

Query

SQL_Statement

SELECT zl.application_id application_id ,zl.entity_code entity_code , zl.event_class_code evevt_class_code , zl.trx_id trx_id , zl.tax tax ,zl.tax_id tax_id ,zl.tax_regime_code tax_regime_code ,zl.tax_jurisdiction_code tax_jurisdiction_code ,zl.tax_rate_code tax_rate_code ,zl.tax_rate tax_rate ,zl.tax_amt_included_flag tax_amt_included_flag ,zl.tax_point_basis tax_point_basis ,zl.tax_amt tax_amt ,zl.Trx_line_id Trx_line_id ,zl.Trx_level_type Trx_level_type ,zl.trx_currency_code trx_currency_code ,NVL((SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = zl.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id = zl.internal_organization_id AND acct.ledger_id = zl.ledger_id), (SELECT tax_liab_acct_ccid FROM zx_accounts acct WHERE acct.tax_account_entity_id = zl.tax_rate_id AND acct.tax_account_entity_code = 'RATES' AND acct.internal_organization_id IS NULL AND acct.ledger_id = zl.ledger_id)) TAX_LIABILITY_CCID FROM zx_lines zl WHERE zl.application_id = 401 AND zl.entity_code = 'SHIPMENTS' AND zl.event_class_code = 'TRANSFER_ORDER_SHIPMENT'