1. Tables and Views for Financials
  2. FLA_REVENUE_LOAD_REQUESTS_V

FLA_REVENUE_LOAD_REQUESTS_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

BU_NAME

LOAD_REQUEST_ID

IMPORT_TYPE

IMPORT_SUBTYPE

Query

SQL_Statement

select DISTINCT bu_name,load_request_id,import_type,import_subtype from (

SELECT bu_name, load_request_id, 'IMPORT_PROPERTIES' import_type, 'MANAGE' import_subtype

FROM fla_properties_int

WHERE (import_status_code is null or import_status_code = 'PENDING')

and import_request_id is null

union all

SELECT bu_name, load_request_id, 'IMPORT_REVENUE' import_type, transaction_type_code import_subtype

FROM fla_leases_int

WHERE (import_status_code is null or import_status_code = 'PENDING')

and lease_type_code = 'REVENUE'

and import_request_id is null

union all

SELECT bu_name, load_request_id, 'IMPORT_REVENUE' import_type, 'MISCELLANEOUS_PAYMENT' import_subtype

FROM fla_miscellaneous_payments_int

WHERE (import_status_code is null or import_status_code = 'PENDING')

and schedule_type_code = 'BILLING'

and import_request_id is null)