SPL_PRD_SVW

(SQL View)
 Index Back

Search view for prod ord

KPN 12/19/02: Added

SELECT DISTINCT A.PROBINST , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.INV_ITEM_ID , A.CONFIG_CODE , A.PLAN_START_DTTM , A.PLAN_END_DTTM , A.PROD_STATUS , D.DESCR FROM PS_PL_PRDNID_HEADR A , PS_SET_CNTRL_REC C , PS_MASTER_ITEM_TBL D WHERE C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETID = D.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID

  • Related Language Record: SPL_PRD_LSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

    Prompt Table: SP_PRBINS_NONVW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: PL_PI_BU_MG_VW

    3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

    Prompt Table: PL_PRDN_PID_VW

    4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PL_PI_BU_ITM_VW

    5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: PL_PI_BITMCG_VW

    6 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
    7 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
    8 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
    10=Entered
    15=Firmed
    20=Released
    30=In Process
    40=Pend Cmpl
    50=Completed
    60=Clsd/Labor
    70=Clsd/Acctg
    90=Canceled
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description