DARTS : UM_SF_ACCTG_VW

SELECT A.RUN_DT,
       A.SEQNUM,
       A.SF_LINE_NBR,
       A.IN_PROCESS_FLG,
       A.BUSINESS_UNIT_GL,
       A.JOURNAL_ID,
       A.JOURNAL_DATE,
       A.JOURNAL_LINE,
       A.ACCOUNT,
       A.ALTACCT,
       A.DEPTID,
       A.OPERATING_UNIT,
       A.PRODUCT,
       A.FUND_CODE,
       A.CLASS_FLD,
       A.PROGRAM_CODE,
       A.BUDGET_REF,
       A.AFFILIATE,
       A.AFFILIATE_INTRA1,
       A.AFFILIATE_INTRA2,
       A.CHARTFIELD1,
       A.CHARTFIELD2,
       A.CHARTFIELD3,
       A.PROJECT_ID,
       A.STATISTICS_CODE,
       A.STATISTIC_AMOUNT,
       A.MONETARY_AMOUNT,
       A.JRNL_LN_REF,
       A.OPEN_ITEM_STATUS,
       A.LINE_DESCR,
       A.JRNL_LINE_STATUS,
       A.JOURNAL_LINE_DATE,
       A.BUSINESS_UNIT,
       A.APPL_JRNL_ID,
       A.ACCOUNTING_DT,
       A.GL_DISTRIB_STATUS,
       A.PROCESS_INSTANCE,
       A.CURRENCY_CD,
       A.ACCOUNTING_PERIOD,
       A.FISCAL_YEAR,
       A.FOREIGN_AMOUNT,
       A.FOREIGN_CURRENCY,
       A.LEDGER,
       A.LEDGER_GROUP,
       A.EXT_GL_CHARTFLD,
       A.EMPLID,
       EMPL.NAME,
       A.ITEM_NBR,
       A.BUDGET_PERIOD,
       A.RT_TYPE,
       A.RATE_DIV,
       A.RATE_MULT,
       A.SF_EXT_ORG_ID,
       A.SF_DEPOSIT_ID,
       A.SF_GL_RUN_INSTANCE,
       B.DESCR,
       C.DESCR,
       D.DESCR,
       E.DESCR,
       F.DESCR,
       H.DESCR,
       I.DESCR,
       G.UM_HR_DEPTID,
       G.UM_HR_DEPT_DESCR
  FROM PS_SF_ACCTG_LN     A,
       PS_DEPT_TBL        B,
       PS_GL_ACCOUNT_TBL  C,
       PS_PROGRAM_TBL     D,
       PS_PROJECT         E,
       PS_OPER_UNIT_TBL   F,
       PS_UM_HR_XREF      G,
       PS_FUND_TBL        H,
       PS_CLASS_CF_TBL    I,
       PS_UM_FGLEMPLOY_VW EMPL
 WHERE B.SETID = 'UMSYS'
   AND A.DEPTID = B.DEPTID
   AND B.EFFDT = (SELECT MAX(B_ED.EFFDT)
                    FROM PS_DEPT_TBL B_ED
                   WHERE B.SETID = B_ED.SETID
                     AND B.DEPTID = B_ED.DEPTID
                     AND B_ED.EFFDT <= A.ACCOUNTING_DT)
   AND C.SETID(+) = 'UMSYS'
   AND C.ACCOUNT = A.ACCOUNT
   AND C.EFFDT = (SELECT MAX(C_ED.EFFDT)
                    FROM PS_GL_ACCOUNT_TBL C_ED
                   WHERE C.SETID = C_ED.SETID
                     AND C.ACCOUNT = C_ED.ACCOUNT
                     AND C_ED.EFFDT <= A.ACCOUNTING_DT)
   AND D.SETID(+) = 'UMSYS'
   AND D.PROGRAM_CODE(+) = A.PROGRAM_CODE
   AND (D.EFFDT = (SELECT MAX(D_ED.EFFDT)
                     FROM PS_PROGRAM_TBL D_ED
                    WHERE D.SETID = D_ED.SETID
                      AND D.PROGRAM_CODE = D_ED.PROGRAM_CODE
                      AND D_ED.EFFDT <= A.ACCOUNTING_DT) OR
       D.EFFDT IS NULL)
   AND E.BUSINESS_UNIT(+) = 'UMSYS'
   AND E.PROJECT_ID(+) = A.PROJECT_ID
   AND F.SETID(+) = 'UMSYS'
   AND F.OPERATING_UNIT(+) = A.OPERATING_UNIT
   AND (F.EFFDT = (SELECT MAX(F_ED.EFFDT)
                     FROM PS_OPER_UNIT_TBL F_ED
                    WHERE F.SETID = F_ED.SETID
                      AND F.OPERATING_UNIT = F_ED.OPERATING_UNIT
                      AND F_ED.EFFDT <= A.ACCOUNTING_DT) OR
       F.EFFDT IS NULL)
   AND A.DEPTID = G.DEPTID(+)
   AND H.SETID(+) = 'UMSYS'
   AND H.FUND_CODE(+) = A.FUND_CODE
   AND (H.EFFDT = (SELECT MAX(H_ED.EFFDT)
                     FROM PS_FUND_TBL H_ED
                    WHERE H.SETID = H_ED.SETID
                      AND H.FUND_CODE = H_ED.FUND_CODE
                      AND H_ED.EFFDT <= A.ACCOUNTING_DT) OR
       H.EFFDT IS NULL)
   AND I.SETID(+) = 'UMSYS'
   AND I.CLASS_FLD(+) = A.CLASS_FLD
   AND (I.EFFDT = (SELECT MAX(I_ED.EFFDT)
                     FROM PS_CLASS_CF_TBL I_ED
                    WHERE I.SETID = I_ED.SETID
                      AND I.CLASS_FLD = I_ED.CLASS_FLD
                      AND I_ED.EFFDT <= A.ACCOUNTING_DT) OR
       I.EFFDT IS NULL)
   AND EMPL.EMPLID(+) = A.EMPLID
   AND EMPL.BUSINESS_UNIT(+) = A.BUSINESS_UNIT_GL;