FLA_XLA_REV_EQP_ACCT_LINES_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

LINES_LEASE_DETAIL_ID ASSET_NUMBER ACCOUNTED_AMOUNT 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 PREVIOUS_CONVERSION_DATE PREVIOUS_CONVERSION_RATE PREVIOUS_CONV_RATE_TYPE_CODE EVENT_ID RECEIVABLES_ACCOUNT REVENUE_ACCOUNT RECEIVABLES_CLEARING_ACCOUNT ACCRUED_ASSET_ACCOUNT REVENUE_EQP_DR_ACCT_CLASS REVENUE_EQP_CR_ACCT_CLASS ACCRUAL_METHOD_CODE

Query

SQL_Statement

SELECT flath.lease_detail_id lines_lease_detail_id, flatl.asset_number asset_number, flatl.accounted_amount accounted_amount, fpav.gain_loss 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, previous_conversion_date, nvl(flatl.previous_conversion_rate, flatl.conversion_rate) previous_conversion_rate, nvl(flatl.previous_conv_rate_type_code, flatl.conversion_rate_type_code) previous_conv_rate_type_code, 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_eqp_dr_acct_class, decode(fla.lease_type_code, 'REVENUE', flatl.cr_account_class_code, NULL) revenue_eqp_cr_acct_class, decode(flaso.primary_regime_code, flath.regime_code, flaph.primary_accrual_method_code, flaph.secondary_accrual_method_code) accrual_method_code FROM fla_accounting_headers_all flath, ( SELECT fal.transaction_id, fal.accounted_amount, fal.dr_account_class_code, fal.cr_account_class_code, fal.currency_code, fal.conversion_date, fal.conversion_rate, fal.conversion_rate_type_code, fal.schedule_type_code, fal.entered_amount, fal.payment_number, fal.line_num, fal.payment_item_id, fal.transaction_line_id, fal.applied_to_line_id, fal.parent_transaction_line_id, nvl(fal.previous_conversion_date, decode(fsh.parent_record_id, NULL, fsh.amortization_start_date,( SELECT fshp.amortization_start_date FROM fla_schedule_headers fshp WHERE fshp.schedule_header_id = fsh.parent_record_id ))) previous_conversion_date, fal.previous_conversion_rate, fal.previous_conv_rate_type_code, fal.asset_number FROM fla_accounting_lines fal, fla_schedule_headers fsh WHERE fsh.schedule_header_id = fal.schedule_header_id ) flatl, fla_xla_rev_eqp_asset_payact_v fpav, fla_leases_all fla, fla_lease_payment_headers flaph, fla_system_options_all flaso 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 flatl.payment_number <> '00000') OR (flatl.payment_number = fpav.payment_number AND flatl.asset_number = fpav.asset_number and flatl.payment_number = '00000')) AND flath.lease_id = fla.lease_id AND fla.lease_type_code = 'REVENUE' AND fla.lease_asset_type_code = 'EQUIPMENT' AND flath.org_id = flaso.org_id AND flatl.payment_number = flaph.payment_number (+) AND fpav.lease_detail_id = flaph.lease_detail_id (+)