RF_SO_AGINGCLVW

(SQL View)
 Index Back

Service Order Aging Analysis

This view is used by the RF_SO_AGE Analytic Model

SELECT DISTINCT A2.PROBINST , %NumToChar(A.BO_ID_CUST) , A.PRODUCT_ID , E.SETID , B.LANGUAGE_CD , B.DAY_RANGE FROM PS_RF_SO_HDR A , PS_SET_CNTRL_REC E , PS_RF_DATE_CFG_LNG B , PS_RF_SO_AGE A1 , PS_RF_SO_AGE_INST A2 , PS_RF_DATE_CONFIG B1 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 B1.FROM_DAY AND B1.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 AND B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SEQNUM = B1.SEQNUM

  • Related Language Record for RF_SO_AGINGC_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DAY_RANGE Character(15) VARCHAR2(15) NOT NULL Range of Days for reporting purposes.