FLA_XLA_PAY_ACCOUNTING_LINES

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
LINES_LEASE_DETAIL_ID ACCOUNTED_AMOUNT DEBIT_ACCOUNT_CLASS CREDIT_ACCOUNT_CLASS ROU_ACCOUNT LIABILITY_ACCOUNT RESERVE_ACCOUNT INT_EXP_ACCOUNT AMORT_ACCOUNT LEASE_EXP_ACCOUNT GAIN_LOSS_ACCOUNT ACCUM_AMORT_ACCOUNT PAY_CLEAR_ACCOUNT ROU_ADJ_LOSS_ACCOUNT FOREX_GAIN_LOSS_ACCOUNT CURRENCY_CODE CONVERSION_DATE CONVERSION_RATE CONVERSION_RATE_TYPE_CODE SCHEDULE_TYPE_CODE ENTERED_AMOUNT PAYMENT_NUMBER LINE_NUMBER LINES_PAYMENT_ITEM_ID TRANSACTION_LINE_ID APPLIED_TO_LINE_ID PARENT_TRANSACTION_LINE_ID REVERSAL_LINE_INDICATOR EVENT_ID RECEIVABLES_ACCOUNT REVENUE_ACCOUNT RECEIVABLES_CLEARING_ACCOUNT ACCRUED_ASSET_ACCOUNT REVENUE_DEBIT_ACCOUNT_CLASS REVENUE_CREDIT_ACCOUNT_CLASS NON_COMP_EXP_ACCOUNT

Name

LINES_LEASE_DETAIL_ID

ACCOUNTED_AMOUNT

DEBIT_ACCOUNT_CLASS

CREDIT_ACCOUNT_CLASS

ROU_ACCOUNT

LIABILITY_ACCOUNT

RESERVE_ACCOUNT

INT_EXP_ACCOUNT

AMORT_ACCOUNT

LEASE_EXP_ACCOUNT

GAIN_LOSS_ACCOUNT

ACCUM_AMORT_ACCOUNT

PAY_CLEAR_ACCOUNT

ROU_ADJ_LOSS_ACCOUNT

FOREX_GAIN_LOSS_ACCOUNT

CURRENCY_CODE

CONVERSION_DATE

CONVERSION_RATE

CONVERSION_RATE_TYPE_CODE

SCHEDULE_TYPE_CODE

ENTERED_AMOUNT

PAYMENT_NUMBER

LINE_NUMBER

LINES_PAYMENT_ITEM_ID

TRANSACTION_LINE_ID

APPLIED_TO_LINE_ID

PARENT_TRANSACTION_LINE_ID

REVERSAL_LINE_INDICATOR

EVENT_ID

RECEIVABLES_ACCOUNT

REVENUE_ACCOUNT

RECEIVABLES_CLEARING_ACCOUNT

ACCRUED_ASSET_ACCOUNT

REVENUE_DEBIT_ACCOUNT_CLASS

REVENUE_CREDIT_ACCOUNT_CLASS

NON_COMP_EXP_ACCOUNT

Query

SQL_Statement
SELECT flath.lease_detail_id lines_lease_detail_id, flatl.accounted_amount accounted_amount, DECODE(fla.lease_type_code, 'EXPENSE', flatl.dr_account_class_code, NULL) debit_account_class, DECODE(fla.lease_type_code, 'EXPENSE', flatl.cr_account_class_code, NULL) credit_account_class, fpav.right_of_use rou_account, fpav.lease_liability liability_account, fpav.reserve reserve_account, fpav.interest_expense int_exp_account, fpav.amortization amort_account, fpav.lease_expense lease_exp_account, fpav.gain_loss gain_loss_account, fpav.accumulated_amortization accum_amort_account, fpav.ap_clearing pay_clear_account, fpav.rou_adj_loss rou_adj_loss_account, fpav.forex_gain_loss forex_gain_loss_account, flatl.currency_code currency_code, flatl.conversion_date conversion_date, flatl.conversion_rate conversion_rate, flatl.conversion_rate_type_code conversion_rate_type_code, flatl.schedule_type_code schedule_type_code, flatl.entered_amount entered_amount, flatl.payment_number payment_number, flatl.line_num line_number, flatl.payment_item_id lines_payment_item_id, flatl.transaction_line_id transaction_line_id, flatl.applied_to_line_id applied_to_line_id, flatl.parent_transaction_line_id parent_transaction_line_id, decode(flatl.parent_transaction_line_id,NULL,'N','Y') reversal_line_indicator, flath.event_id event_id, fpav.accounts_receivable receivables_account, fpav.revenue revenue_account, fpav.receivables_clearing receivables_clearing_account, fpav.accrued_asset accrued_asset_account, DECODE(fla.lease_type_code, 'REVENUE', flatl.dr_account_class_code, NULL) revenue_debit_account_class, DECODE(fla.lease_type_code, 'REVENUE', flatl.cr_account_class_code, NULL) revenue_credit_account_class, fpav.non_compliance_expense non_comp_exp_account FROM fla_accounting_headers_all flath, fla_accounting_lines flatl, fla_xla_payment_accounts_v fpav, fla_leases_all fla WHERE flatl.transaction_id = flath.transaction_id AND flath.lease_id = fpav.lease_id AND flath.lease_detail_id = fpav.lease_detail_id AND flath.ledger_id = fpav.ledger_id AND flatl.payment_number = fpav.payment_number AND flath.lease_id = fla.lease_id

SQL_Statement

SELECT

flath.lease_detail_id lines_lease_detail_id,

flatl.accounted_amount accounted_amount,

DECODE(fla.lease_type_code, 'EXPENSE', flatl.dr_account_class_code, NULL) debit_account_class,

DECODE(fla.lease_type_code, 'EXPENSE', flatl.cr_account_class_code, NULL) credit_account_class,

fpav.right_of_use rou_account,

fpav.lease_liability liability_account,

fpav.reserve reserve_account,

fpav.interest_expense int_exp_account,

fpav.amortization amort_account,

fpav.lease_expense lease_exp_account,

fpav.gain_loss gain_loss_account,

fpav.accumulated_amortization accum_amort_account,

fpav.ap_clearing pay_clear_account,

fpav.rou_adj_loss rou_adj_loss_account,

fpav.forex_gain_loss forex_gain_loss_account,

flatl.currency_code currency_code,

flatl.conversion_date conversion_date,

flatl.conversion_rate conversion_rate,

flatl.conversion_rate_type_code conversion_rate_type_code,

flatl.schedule_type_code schedule_type_code,

flatl.entered_amount entered_amount,

flatl.payment_number payment_number,

flatl.line_num line_number,

flatl.payment_item_id lines_payment_item_id,

flatl.transaction_line_id transaction_line_id,

flatl.applied_to_line_id applied_to_line_id,

flatl.parent_transaction_line_id parent_transaction_line_id,

decode(flatl.parent_transaction_line_id,NULL,'N','Y') reversal_line_indicator,

flath.event_id event_id,

fpav.accounts_receivable receivables_account,

fpav.revenue revenue_account,

fpav.receivables_clearing receivables_clearing_account,

fpav.accrued_asset accrued_asset_account,

DECODE(fla.lease_type_code, 'REVENUE', flatl.dr_account_class_code, NULL) revenue_debit_account_class,

DECODE(fla.lease_type_code, 'REVENUE', flatl.cr_account_class_code, NULL) revenue_credit_account_class,

fpav.non_compliance_expense non_comp_exp_account

FROM

fla_accounting_headers_all flath,

fla_accounting_lines flatl,

fla_xla_payment_accounts_v fpav,

fla_leases_all fla

WHERE

flatl.transaction_id = flath.transaction_id

AND flath.lease_id = fpav.lease_id

AND flath.lease_detail_id = fpav.lease_detail_id

AND flath.ledger_id = fpav.ledger_id

AND flatl.payment_number = fpav.payment_number

AND flath.lease_id = fla.lease_id