PV_CPXLAT_RL_VW

(SQL View)
 Index Back

Catalog Load Item Status


SELECT DISTINCT B.PROCESS_INSTANCE , B.PV_CP_ITM_STATUS , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A , PS_PV_CP_LOAD B WHERE A.FIELDNAME = 'PV_CP_ITM_STATUS' AND A.FIELDVALUE = B.PV_CP_ITM_STATUS AND A.EFFDT = ( SELECT MAX(I.EFFDT) FROM PSXLATITEMLANG I WHERE I.FIELDNAME = A.FIELDNAME AND I.LANGUAGE_CD = A.LANGUAGE_CD AND I.FIELDVALUE = A.FIELDVALUE AND I.EFFDT <= %CurrentDateIn) AND A.LANGUAGE_CD <> ( SELECT B.LANGUAGE_CD FROM PSOPTIONS B)

  • Related Language Record for PV_CPXLATSTS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 PV_CP_ITM_STATUS Character(1) VARCHAR2(1) NOT NULL MarketSite Item Status
    1=Ready to Build Items
    2=Invalid or Missing Supplier
    3=Invalid or Missing Category
    4=Item Already Exists
    5=Invalid Unit of Measure
    6=Processing Complete
    7=Item to be inactivated
    8=Price to be updated
    9=Item to be updated
    A=Item Doesn't Exist
    B=Item Load Error
    C=Exists in other catalog
    D=Duplicate Items in catalog
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name