RF_SO_AGINGC_VW

(SQL View)
 Index Back

Service Order Aging Analysis

This view is used by the RF_SO_AGE Analytic Model

SELECT A2.PROBINST , %NumToChar(A.BO_ID_CUST) , A.PRODUCT_ID , E.SETID , B.DAY_RANGE , COUNT(*) FROM PS_RF_SO_HDR A , PS_SET_CNTRL_REC E , PS_RF_DATE_CONFIG B , PS_RF_SO_AGE A1 , PS_RF_SO_AGE_INST A2 WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'PROD_ITEM' AND A.SO_STATUS = 'O' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND (%DateDiff(A.SO_DATE, %CurrentDateIn) + 1) BETWEEN B.FROM_DAY AND B.TO_DAY AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A1.OPRID = A2.OPRID AND A1.RUN_CNTL_ID = A2.RUN_CNTL_ID AND A1.BO_ID_CUST = A.BO_ID_CUST GROUP BY A2.PROBINST, A.BUSINESS_UNIT, %NumToChar(A.BO_ID_CUST) , A.PRODUCT_ID, E.SETID, B.DAY_RANGE

  • Related Language Record: RF_SO_AGINGCLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    2 BO_ID_STR Character(32) VARCHAR2(32) NOT NULL BO ID as a string
    3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    5 DAY_RANGE Character(15) VARCHAR2(15) NOT NULL Range of Days for reporting purposes.
    6 TOTAL_CNT Number(4,0) SMALLINT NOT NULL Total Objects