Skip to content

Latest commit

 

History

History
29 lines (23 loc) · 974 Bytes

retained_earning_selector_view.md

File metadata and controls

29 lines (23 loc) · 974 Bytes

finance.retained_earning_selector_view view

Schema finance
Materialized View Name retained_earning_selector_view
Owner frapid_db_user
Tablespace DEFAULT
Description

Source:

 CREATE OR REPLACE VIEW finance.retained_earning_selector_view
 AS
 SELECT account_scrud_view.account_id AS retained_earning_id,
    account_scrud_view.account_name AS retained_earning_name
   FROM finance.account_scrud_view
  WHERE (account_scrud_view.account_master_id IN ( SELECT get_account_master_ids.get_account_master_ids
           FROM finance.get_account_master_ids(15300) get_account_master_ids(get_account_master_ids)))
  ORDER BY account_scrud_view.account_id;

Related Contents