FLA_LEASE_PAYMENT_TAXES

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
LEASE_ID LEASE_NUMBER LEASE_NAME ORG_ID LEASE_DETAIL_ID VERSION_NUM VERSION_TYPE_CODE COMMENCEMENT_DATE PAYMENT_TAX_ID PAYMENT_NUMBER PAYMENT_TAX_LINE_NUMBER CURRENCY_CODE TAX_RATE_CODE TAX_JURISDICTION_CODE TAX_REGIME_CODE TAX INCLUDE_IN_ROU_FLAG TAX_DETERMINANTS_SOURCE_CODE TAX_ON_INCREASE_ITEMS_FLAG PARENT_RECORD_ID EFFECTIVE_DATE TAX_RATE_ID TAX_RATE RECOVERABLE_TAX_RATE RECOVERY_TYPE_CODE EFFECTIVE_TAX_RATE TAX_PAYMENT_ITEMS_IMPACT_FLAG TAX_SCHEDULES_IMPACT_FLAG TRANSACTION_TYPE_CODE PRIMARY_REGIME_FLAG REGIME_CODE LEDGER_ID LEASE_CLASSIFICATION_CODE ROU_ASSET_FLAG LIABILITY_FLAG TAX_TRANSACTION_FLAG

Name

LEASE_ID

LEASE_NUMBER

LEASE_NAME

ORG_ID

LEASE_DETAIL_ID

VERSION_NUM

VERSION_TYPE_CODE

COMMENCEMENT_DATE

PAYMENT_TAX_ID

PAYMENT_NUMBER

PAYMENT_TAX_LINE_NUMBER

CURRENCY_CODE

TAX_RATE_CODE

TAX_JURISDICTION_CODE

TAX_REGIME_CODE

TAX

INCLUDE_IN_ROU_FLAG

TAX_DETERMINANTS_SOURCE_CODE

TAX_ON_INCREASE_ITEMS_FLAG

PARENT_RECORD_ID

EFFECTIVE_DATE

TAX_RATE_ID

TAX_RATE

RECOVERABLE_TAX_RATE

RECOVERY_TYPE_CODE

EFFECTIVE_TAX_RATE

TAX_PAYMENT_ITEMS_IMPACT_FLAG

TAX_SCHEDULES_IMPACT_FLAG

TRANSACTION_TYPE_CODE

PRIMARY_REGIME_FLAG

REGIME_CODE

LEDGER_ID

LEASE_CLASSIFICATION_CODE

ROU_ASSET_FLAG

LIABILITY_FLAG

TAX_TRANSACTION_FLAG

Query

SQL_Statement
SELECT pt.lease_id, pt.lease_number, pt.lease_name, pt.org_id, pt.lease_detail_id, pt.version_num, pt.version_type_code, pt.commencement_date, pt.payment_tax_id, pt.payment_number, pt.payment_tax_line_number, pt.currency_code, pt.tax_rate_code, pt.tax_jurisdiction_code, pt.tax_regime_code, pt.tax, pt.include_in_rou_flag, pt.tax_determinants_source_code, pt.tax_on_increase_items_flag, pt.parent_record_id, pt.effective_date, pt.tax_rate_id, pt.tax_rate, pt.recoverable_tax_rate, pt.recovery_type_code, pt.effective_tax_rate, pt.tax_payment_items_impact_flag, pt.tax_schedules_impact_flag, pt.transaction_type_code, pt.primary_regime_flag, pt.regime_code, pt.ledger_id, pt.lease_classification_code, pt.rou_asset_flag, pt.liability_flag, 'Y' tax_transaction_flag FROM( SELECT pt.lease_id, la.lease_number, la.lease_name, la.org_id, ld.lease_detail_id, ld.version_num, ld.version_type_code, ld.commencement_date, pt.payment_tax_id, pt.payment_number, pt.payment_tax_line_number, ph.currency_code, pt.tax_rate_code, pt.tax_jurisdiction_code, pt.tax_regime_code, pt.tax, pt.non_recovery_tax_rou_flag include_in_rou_flag, pt.tax_determinants_source_code, pt.calc_tax_on_increase_amt_flag tax_on_increase_items_flag, pt.parent_record_id, pt.tax_rate_effective_from effective_date, pt.tax_rate_id, pt.tax_rate, pt.recoverable_tax_rate, pt.recovery_type_code, NVL(pt.tax_rate, 0) - ROUND((NVL(pt.tax_rate, 0)* NVL(pt.recoverable_tax_rate, 0)/100), 5) effective_tax_rate, pt.tax_payment_items_impact_flag, pt.schedules_impact_flag tax_schedules_impact_flag, 'NON_RECOVERABLE' transaction_type_code, rd.primary_flag primary_regime_flag, rd.regime_code, rd.ledger_id, DECODE(rd.primary_flag, 'Y', ld.lease_classification_code, NVL(ld.lease_secondary_classif_code, ld.lease_classification_code)) lease_classification_code, ph.rou_asset_flag, ph.liability_flag FROM fla_leases_all la, fla_lease_details ld, fla_regime_details_v rd, fla_lease_payment_taxes pt, fla_lease_payment_headers ph WHERE la.lease_id = ld.lease_id AND la.org_id = rd.org_id AND ld.lease_detail_id = pt.lease_detail_id AND ld.lease_id = pt.lease_id AND pt.lease_id = ph.lease_id AND pt.lease_detail_id = ph.lease_detail_id AND pt.payment_number = ph.payment_number AND ph.change_type_code <> 'DELETE' AND pt.change_type_code <> 'DELETE' UNION ALL SELECT pt.lease_id, la.lease_number, la.lease_name, la.org_id, ld.lease_detail_id, ld.version_num, ld.version_type_code, ld.commencement_date, pt.payment_tax_id, pt.payment_number, pt.payment_tax_line_number, ph.currency_code, pt.recovery_tax_rate_code tax_rate_code, pt.tax_jurisdiction_code, pt.tax_regime_code, pt.tax, pt.recovery_tax_rou_flag include_in_rou_flag, pt.tax_determinants_source_code, pt.calc_tax_on_increase_amt_flag tax_on_increase_items_flag, pt.parent_record_id, pt.recovery_rate_effective_from effective_date, pt.recovery_tax_rate_id tax_rate_id, pt.tax_rate, pt.recoverable_tax_rate, pt.recovery_type_code, ROUND((NVL(pt.tax_rate, 0)* NVL(pt.recoverable_tax_rate, 0)/100), 5) effective_tax_rate, pt.tax_payment_items_impact_flag, pt.schedules_impact_flag tax_schedules_impact_flag, 'RECOVERABLE' transaction_type_code, rd.primary_flag primary_regime_flag, rd.regime_code, rd.ledger_id, DECODE(rd.primary_flag, 'Y', ld.lease_classification_code, NVL(ld.lease_secondary_classif_code, ld.lease_classification_code)) lease_classification_code, ph.rou_asset_flag, ph.liability_flag FROM fla_leases_all la, fla_lease_details ld, fla_regime_details_v rd, fla_lease_payment_taxes pt, fla_lease_payment_headers ph WHERE la.lease_id = ld.lease_id AND la.org_id = rd.org_id AND ld.lease_detail_id = pt.lease_detail_id AND ld.lease_id = pt.lease_id AND pt.lease_id = ph.lease_id AND pt.lease_detail_id = ph.lease_detail_id AND pt.payment_number = ph.payment_number AND ph.change_type_code <> 'DELETE' AND pt.change_type_code <> 'DELETE' ) pt

SQL_Statement

SELECT pt.lease_id,

pt.lease_number,

pt.lease_name,

pt.org_id,

pt.lease_detail_id,

pt.version_num,

pt.version_type_code,

pt.commencement_date,

pt.payment_tax_id,

pt.payment_number,

pt.payment_tax_line_number,

pt.currency_code,

pt.tax_rate_code,

pt.tax_jurisdiction_code,

pt.tax_regime_code,

pt.tax,

pt.include_in_rou_flag,

pt.tax_determinants_source_code,

pt.tax_on_increase_items_flag,

pt.parent_record_id,

pt.effective_date,

pt.tax_rate_id,

pt.tax_rate,

pt.recoverable_tax_rate,

pt.recovery_type_code,

pt.effective_tax_rate,

pt.tax_payment_items_impact_flag,

pt.tax_schedules_impact_flag,

pt.transaction_type_code,

pt.primary_regime_flag,

pt.regime_code,

pt.ledger_id,

pt.lease_classification_code,

pt.rou_asset_flag,

pt.liability_flag,

'Y' tax_transaction_flag

FROM(

SELECT pt.lease_id,

la.lease_number,

la.lease_name,

la.org_id,

ld.lease_detail_id,

ld.version_num,

ld.version_type_code,

ld.commencement_date,

pt.payment_tax_id,

pt.payment_number,

pt.payment_tax_line_number,

ph.currency_code,

pt.tax_rate_code,

pt.tax_jurisdiction_code,

pt.tax_regime_code,

pt.tax,

pt.non_recovery_tax_rou_flag include_in_rou_flag,

pt.tax_determinants_source_code,

pt.calc_tax_on_increase_amt_flag tax_on_increase_items_flag,

pt.parent_record_id,

pt.tax_rate_effective_from effective_date,

pt.tax_rate_id,

pt.tax_rate,

pt.recoverable_tax_rate,

pt.recovery_type_code,

NVL(pt.tax_rate, 0) - ROUND((NVL(pt.tax_rate, 0)* NVL(pt.recoverable_tax_rate, 0)/100), 5) effective_tax_rate,

pt.tax_payment_items_impact_flag,

pt.schedules_impact_flag tax_schedules_impact_flag,

'NON_RECOVERABLE' transaction_type_code,

rd.primary_flag primary_regime_flag,

rd.regime_code,

rd.ledger_id,

DECODE(rd.primary_flag, 'Y', ld.lease_classification_code, NVL(ld.lease_secondary_classif_code, ld.lease_classification_code)) lease_classification_code,

ph.rou_asset_flag,

ph.liability_flag

FROM fla_leases_all la,

fla_lease_details ld,

fla_regime_details_v rd,

fla_lease_payment_taxes pt,

fla_lease_payment_headers ph

WHERE la.lease_id = ld.lease_id

AND la.org_id = rd.org_id

AND ld.lease_detail_id = pt.lease_detail_id

AND ld.lease_id = pt.lease_id

AND pt.lease_id = ph.lease_id

AND pt.lease_detail_id = ph.lease_detail_id

AND pt.payment_number = ph.payment_number

AND ph.change_type_code <> 'DELETE'

AND pt.change_type_code <> 'DELETE'

UNION ALL

SELECT pt.lease_id,

la.lease_number,

la.lease_name,

la.org_id,

ld.lease_detail_id,

ld.version_num,

ld.version_type_code,

ld.commencement_date,

pt.payment_tax_id,

pt.payment_number,

pt.payment_tax_line_number,

ph.currency_code,

pt.recovery_tax_rate_code tax_rate_code,

pt.tax_jurisdiction_code,

pt.tax_regime_code,

pt.tax,

pt.recovery_tax_rou_flag include_in_rou_flag,

pt.tax_determinants_source_code,

pt.calc_tax_on_increase_amt_flag tax_on_increase_items_flag,

pt.parent_record_id,

pt.recovery_rate_effective_from effective_date,

pt.recovery_tax_rate_id tax_rate_id,

pt.tax_rate,

pt.recoverable_tax_rate,

pt.recovery_type_code,

ROUND((NVL(pt.tax_rate, 0)* NVL(pt.recoverable_tax_rate, 0)/100), 5) effective_tax_rate,

pt.tax_payment_items_impact_flag,

pt.schedules_impact_flag tax_schedules_impact_flag,

'RECOVERABLE' transaction_type_code,

rd.primary_flag primary_regime_flag,

rd.regime_code,

rd.ledger_id,

DECODE(rd.primary_flag, 'Y', ld.lease_classification_code, NVL(ld.lease_secondary_classif_code, ld.lease_classification_code)) lease_classification_code,

ph.rou_asset_flag,

ph.liability_flag

FROM fla_leases_all la,

fla_lease_details ld,

fla_regime_details_v rd,

fla_lease_payment_taxes pt,

fla_lease_payment_headers ph

WHERE la.lease_id = ld.lease_id

AND la.org_id = rd.org_id

AND ld.lease_detail_id = pt.lease_detail_id

AND ld.lease_id = pt.lease_id

AND pt.lease_id = ph.lease_id

AND pt.lease_detail_id = ph.lease_detail_id

AND pt.payment_number = ph.payment_number

AND ph.change_type_code <> 'DELETE'

AND pt.change_type_code <> 'DELETE'

) pt