FLA_XLA_ACCOUNTING_HEADERS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

ADDER_RATE DISCOUNT_RATE ORG_ID TRANSACTION_ID TRANSACTION_DATE ACCOUNTING_DATE EVENT_ID TRANSACTION_NUMBER AMORTIZATION_END_DATE AMORTIZATION_START_DATE LEASE_CLASSIFICATION_CODE COMMENCEMENT_DATE LEASE_STATUS_CODE TERMINATION_DATE LEASE_ASSET_TYPE_CODE LEASE_ID LEASE_DETAIL_ID LEASE_VERSION_NAME TRANSACTION_SUBTYPE_CODE LEASE_NAME LEASE_NUMBER LESSOR_NAME LEDGER_ID LEDGER_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME REGIME_CODE TRANSACTION_TYPE_CODE TRANSACTION_REVERSAL_FLAG DETAILS_ATTRIBUTE_CATEGORY DETAILS_ATTRIBUTE_CHAR1 DETAILS_ATTRIBUTE_CHAR10 DETAILS_ATTRIBUTE_CHAR11 DETAILS_ATTRIBUTE_CHAR12 DETAILS_ATTRIBUTE_CHAR13 DETAILS_ATTRIBUTE_CHAR14 DETAILS_ATTRIBUTE_CHAR15 DETAILS_ATTRIBUTE_CHAR2 DETAILS_ATTRIBUTE_CHAR3 DETAILS_ATTRIBUTE_CHAR4 DETAILS_ATTRIBUTE_CHAR5 DETAILS_ATTRIBUTE_CHAR6 DETAILS_ATTRIBUTE_CHAR7 DETAILS_ATTRIBUTE_CHAR8 DETAILS_ATTRIBUTE_CHAR9 DETAILS_ATTRIBUTE_NUMBER1 DETAILS_ATTRIBUTE_NUMBER2 DETAILS_ATTRIBUTE_NUMBER3 DETAILS_ATTRIBUTE_NUMBER4 DETAILS_ATTRIBUTE_NUMBER5 DETAILS_ATTRIBUTE_DATE1 DETAILS_ATTRIBUTE_DATE2 DETAILS_ATTRIBUTE_DATE3 DETAILS_ATTRIBUTE_DATE4 DETAILS_ATTRIBUTE_DATE5 LEASE_TYPE_CODE PARTY_NAME REQUIRE_PROPERTY_DEFN_FLAG SUBLEASE_FLAG

Query

SQL_Statement

SELECT decode(flath.regime_code,flaso.secondary_regime_code,flald.secd_regime_adder_rate,flald.prim_regime_adder_rate) adder_rate, decode(flath.regime_code,flaso.secondary_regime_code,flald.secd_regime_disc_rate_index_id,flald.prim_regime_disc_rate_index_id) discount_rate, flath.org_id org_id, flath.transaction_id transaction_id, flath.transaction_date transaction_date, flath.accounting_date accounting_date, flath.event_id event_id, flath.transaction_number transaction_number, flald.amortization_end_date amortization_end_date, flal.amortization_start_date amortization_start_date, DECODE(flaso.primary_regime_code, flath.regime_code, flald.lease_classification_code, NVL(flald.lease_secondary_classif_code, flald.lease_classification_code)) lease_classification_code, flald.commencement_date commencement_date, flal.lease_status_code lease_status_code, flald.termination_date termination_date, flal.lease_asset_type_code lease_asset_type_code, flal.lease_id lease_id, flald.lease_detail_id lease_detail_id, flald.lease_version_name lease_version_name, flald.transaction_subtype_code transaction_subtype_code, flal.lease_name lease_name, flal.lease_number lease_number, pos.vendor_name lessor_name, flath.ledger_id ledger_id, gll.name ledger_name, flal.legal_entity_id legal_entity_id, le.name legal_entity_name, flath.regime_code regime_code, flath.transaction_type_code transaction_type_code, decode(flath.parent_transaction_id,NULL,'N','Y') transaction_reversal_flag, flald.attribute_category details_attribute_category, flald.attribute_char1 details_attribute_char1, flald.attribute_char10 details_attribute_char10, flald.attribute_char11 details_attribute_char11, flald.attribute_char12 details_attribute_char12, flald.attribute_char13 details_attribute_char13, flald.attribute_char14 details_attribute_char14, flald.attribute_char15 details_attribute_char15, flald.attribute_char2 details_attribute_char2, flald.attribute_char3 details_attribute_char3, flald.attribute_char4 details_attribute_char4, flald.attribute_char5 details_attribute_char5, flald.attribute_char6 details_attribute_char6, flald.attribute_char7 details_attribute_char7, flald.attribute_char8 details_attribute_char8, flald.attribute_char9 details_attribute_char9, flald.attribute_number1 details_attribute_number1, flald.attribute_number2 details_attribute_number2, flald.attribute_number3 details_attribute_number3, flald.attribute_number4 details_attribute_number4, flald.attribute_number5 details_attribute_number5, flald.attribute_date1 details_attribute_date1, flald.attribute_date2 details_attribute_date2, flald.attribute_date3 details_attribute_date3, flald.attribute_date4 details_attribute_date4, flald.attribute_date5 details_attribute_date5, flal.lease_type_code lease_type_code, DECODE (flal.lease_type_code, 'EXPENSE', pos.vendor_name, 'REVENUE', p.party_name) party_name, flald.require_property_defn_flag require_property_defn_flag, flal.sublease_flag sublease_flag FROM fla_accounting_headers_all flath, fla_lease_details flald, fla_leases_all flal, fla_system_options_all flaso, poz_suppliers_v pos, gl_ledgers gll, xle_entity_profiles le, (SELECT hca.cust_account_id, hp.party_name FROM hz_parties hp, hz_cust_accounts hca WHERE hp.party_id = hca.party_id) p WHERE flath.lease_id = flal.lease_id AND flaso.org_id = flath.org_id AND flald.lease_detail_id = flath.lease_detail_id AND flal.vendor_id = pos.vendor_id(+) AND gll.ledger_id = flath.ledger_id AND le.legal_entity_id = flal.legal_entity_id AND flal.bill_to_customer_id = p.cust_account_id(+)