FLA_XLA_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
LEASE_ID LEASE_NUMBER LEASE_NAME VERSION_NUM TRANSACTION_NUMBER TRANSACTION_TYPE_CODE TRANSACTION_DATE ACCOUNTING_DATE TRANSACTION_STATUS REGIME_CODE TRANSACTION_ID PERIOD_NAME TRANSACTION_DESCRIPTION

Query

SQL_Statement

SELECT flal.lease_id lease_id, flal.lease_number lease_number, flal.lease_name lease_name, flath.version_num version_num, flath.transaction_number transaction_number, flath.transaction_type_code transaction_type_code, flath.transaction_date transaction_date, flath.accounting_date accounting_date, flath.transaction_status_code transaction_status, flath.regime_code regime_code, flath.transaction_id transaction_id, flath.period_name period_name, flath.description transaction_description FROM fla_accounting_headers_all flath, fla_leases_all flal WHERE flath.lease_id = flal.lease_id