SCP_POA_HIST2LN

(SQL View)
 Index Back

POA History Lang record

Language view for POA History View based

SELECT DISTINCT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , F.LANGUAGE_CD , CASE WHEN A.CHNG_ORD_BATCH > 0 THEN MCT.MESSAGE_TEXT || ' ' || %NUMTOCHAR(A.CHNG_ORD_BATCH) ELSE F.XLATLONGNAME END FROM PS_PO_POA_HDR_HIST A , PS_PO_HDR B , PSXLATITEMLANG F , PSMSGCATLANG MCT WHERE A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND MCT.MESSAGE_SET_NBR = 10258 AND MCT.MESSAGE_NBR = 9 AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM PSXLATITEMLANG F_ED WHERE F.FIELDNAME = F_ED.FIELDNAME AND F.FIELDVALUE = F_ED.FIELDVALUE AND F_ED.EFFDT <= %CurrentDateIn ) AND B.PO_STATUS = F.FIELDVALUE AND F.FIELDNAME = 'PO_STATUS'

  • Related Language Record for SCP_POA_HIST2VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2