IN_DMD_LST_ILVW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.IN_FULFILL_STATE , A.LAST_PROCESS_INST , B.PRCSTYPE , B.PRCSNAME , C.LANGUAGE_CD , C.DESCR FROM PS_IN_DEMAND A , PSPRCSRQST B , PS_PRCSDEFNLANG C WHERE A.LAST_PROCESS_INST = B.PRCSINSTANCE AND B.PRCSTYPE = C.PRCSTYPE AND B.PRCSNAME = C.PRCSNAME AND A.LAST_PROCESS_INST > 0 AND IN_PROCESS_DATE IS NOT NULL

  • Related Language Record for IN_DMD_LST_I_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUIN_NONVW

    2 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
    10=Pending
    20=Unfulfilled
    30=Releasable
    40=Released
    50=Confirmed
    60=Shipped
    70=Depleted
    90=Canceled
    3 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_ALT_VW

    5 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

    Prompt Table: PRCSDEFN

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description