FLA_XLA_REV_EQP_PAYACCT_DTLS

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
LINES_LEASE_DETAIL_ID 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 EVENT_ID RECEIVABLES_ACCOUNT REVENUE_ACCOUNT RECEIVABLES_CLEARING_ACCOUNT ACCRUED_ASSET_ACCOUNT REVENUE_EQP_DR_ACCT_CLASS REVENUE_EQP_CR_ACCT_CLASS ASSET_NUMBER PAY_ITEM_ATTRIBUTE_CATEGORY PAY_ITEM_ATTRIBUTE_CHAR1 PAY_ITEM_ATTRIBUTE_CHAR10 PAY_ITEM_ATTRIBUTE_CHAR11 PAY_ITEM_ATTRIBUTE_CHAR12 PAY_ITEM_ATTRIBUTE_CHAR13 PAY_ITEM_ATTRIBUTE_CHAR14 PAY_ITEM_ATTRIBUTE_CHAR15 PAY_ITEM_ATTRIBUTE_CHAR2 PAY_ITEM_ATTRIBUTE_CHAR3 PAY_ITEM_ATTRIBUTE_CHAR4 PAY_ITEM_ATTRIBUTE_CHAR5 PAY_ITEM_ATTRIBUTE_CHAR6 PAY_ITEM_ATTRIBUTE_CHAR7 PAY_ITEM_ATTRIBUTE_CHAR8 PAY_ITEM_ATTRIBUTE_CHAR9 PAY_ITEM_ATTRIBUTE_NUMBER1 PAY_ITEM_ATTRIBUTE_NUMBER2 PAY_ITEM_ATTRIBUTE_NUMBER3 PAY_ITEM_ATTRIBUTE_NUMBER4 PAY_ITEM_ATTRIBUTE_NUMBER5 PAY_ITEM_ATTRIBUTE_DATE1 PAY_ITEM_ATTRIBUTE_DATE2 PAY_ITEM_ATTRIBUTE_DATE3 PAY_ITEM_ATTRIBUTE_DATE4 PAY_ITEM_ATTRIBUTE_DATE5 ACCRUAL_METHOD_CODE

Name

LINES_LEASE_DETAIL_ID

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

EVENT_ID

RECEIVABLES_ACCOUNT

REVENUE_ACCOUNT

RECEIVABLES_CLEARING_ACCOUNT

ACCRUED_ASSET_ACCOUNT

REVENUE_EQP_DR_ACCT_CLASS

REVENUE_EQP_CR_ACCT_CLASS

ASSET_NUMBER

PAY_ITEM_ATTRIBUTE_CATEGORY

PAY_ITEM_ATTRIBUTE_CHAR1

PAY_ITEM_ATTRIBUTE_CHAR10

PAY_ITEM_ATTRIBUTE_CHAR11

PAY_ITEM_ATTRIBUTE_CHAR12

PAY_ITEM_ATTRIBUTE_CHAR13

PAY_ITEM_ATTRIBUTE_CHAR14

PAY_ITEM_ATTRIBUTE_CHAR15

PAY_ITEM_ATTRIBUTE_CHAR2

PAY_ITEM_ATTRIBUTE_CHAR3

PAY_ITEM_ATTRIBUTE_CHAR4

PAY_ITEM_ATTRIBUTE_CHAR5

PAY_ITEM_ATTRIBUTE_CHAR6

PAY_ITEM_ATTRIBUTE_CHAR7

PAY_ITEM_ATTRIBUTE_CHAR8

PAY_ITEM_ATTRIBUTE_CHAR9

PAY_ITEM_ATTRIBUTE_NUMBER1

PAY_ITEM_ATTRIBUTE_NUMBER2

PAY_ITEM_ATTRIBUTE_NUMBER3

PAY_ITEM_ATTRIBUTE_NUMBER4

PAY_ITEM_ATTRIBUTE_NUMBER5

PAY_ITEM_ATTRIBUTE_DATE1

PAY_ITEM_ATTRIBUTE_DATE2

PAY_ITEM_ATTRIBUTE_DATE3

PAY_ITEM_ATTRIBUTE_DATE4

PAY_ITEM_ATTRIBUTE_DATE5

ACCRUAL_METHOD_CODE

Query

SQL_Statement
SELECT flath.lease_detail_id lines_lease_detail_id, 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, 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, flatl.asset_number asset_number, flapi.attribute_category pay_item_attribute_category, flapi.attribute1 pay_item_attribute_char1, flapi.attribute10 pay_item_attribute_char10, flapi.attribute11 pay_item_attribute_char11, flapi.attribute12 pay_item_attribute_char12, flapi.attribute13 pay_item_attribute_char13, flapi.attribute14 pay_item_attribute_char14, flapi.attribute15 pay_item_attribute_char15, flapi.attribute2 pay_item_attribute_char2, flapi.attribute3 pay_item_attribute_char3, flapi.attribute4 pay_item_attribute_char4, flapi.attribute5 pay_item_attribute_char5, flapi.attribute6 pay_item_attribute_char6, flapi.attribute7 pay_item_attribute_char7, flapi.attribute8 pay_item_attribute_char8, flapi.attribute9 pay_item_attribute_char9, flapi.attribute_number1 pay_item_attribute_number1, flapi.attribute_number2 pay_item_attribute_number2, flapi.attribute_number3 pay_item_attribute_number3, flapi.attribute_number4 pay_item_attribute_number4, flapi.attribute_number5 pay_item_attribute_number5, flapi.attribute_date1 pay_item_attribute_date1, flapi.attribute_date2 pay_item_attribute_date2, flapi.attribute_date3 pay_item_attribute_date3, flapi.attribute_date4 pay_item_attribute_date4, flapi.attribute_date5 pay_item_attribute_date5, 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, fla_accounting_lines flatl, FLA_XLA_REV_EQP_ASSET_PAYACT_V fpav, fla_leases_all fla, fla_payment_items flapi, 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 fpav.payment_number <> '00000' AND flath.org_id = flaso.org_id AND flatl.payment_number = fpav.payment_number AND flath.lease_id = fla.lease_id AND flatl.payment_item_id = flapi.payment_item_id AND flatl.payment_number = flaph.payment_number AND flath.lease_detail_id = flaph.lease_detail_id

SQL_Statement

SELECT

flath.lease_detail_id lines_lease_detail_id,

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,

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,

flatl.asset_number asset_number,

flapi.attribute_category pay_item_attribute_category,

flapi.attribute1 pay_item_attribute_char1,

flapi.attribute10 pay_item_attribute_char10,

flapi.attribute11 pay_item_attribute_char11,

flapi.attribute12 pay_item_attribute_char12,

flapi.attribute13 pay_item_attribute_char13,

flapi.attribute14 pay_item_attribute_char14,

flapi.attribute15 pay_item_attribute_char15,

flapi.attribute2 pay_item_attribute_char2,

flapi.attribute3 pay_item_attribute_char3,

flapi.attribute4 pay_item_attribute_char4,

flapi.attribute5 pay_item_attribute_char5,

flapi.attribute6 pay_item_attribute_char6,

flapi.attribute7 pay_item_attribute_char7,

flapi.attribute8 pay_item_attribute_char8,

flapi.attribute9 pay_item_attribute_char9,

flapi.attribute_number1 pay_item_attribute_number1,

flapi.attribute_number2 pay_item_attribute_number2,

flapi.attribute_number3 pay_item_attribute_number3,

flapi.attribute_number4 pay_item_attribute_number4,

flapi.attribute_number5 pay_item_attribute_number5,

flapi.attribute_date1 pay_item_attribute_date1,

flapi.attribute_date2 pay_item_attribute_date2,

flapi.attribute_date3 pay_item_attribute_date3,

flapi.attribute_date4 pay_item_attribute_date4,

flapi.attribute_date5 pay_item_attribute_date5,

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,

fla_accounting_lines flatl,

FLA_XLA_REV_EQP_ASSET_PAYACT_V fpav,

fla_leases_all fla,

fla_payment_items flapi,

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 fpav.payment_number <> '00000'

AND flath.org_id = flaso.org_id

AND flatl.payment_number = fpav.payment_number

AND flath.lease_id = fla.lease_id

AND flatl.payment_item_id = flapi.payment_item_id

AND flatl.payment_number = flaph.payment_number

AND flath.lease_detail_id = flaph.lease_detail_id