PV_CPXLATSTS_VW

(SQL View)
 Index Back

Catalog Load Item Status


SELECT DISTINCT B.PROCESS_INSTANCE , B.PV_CP_ITM_STATUS , XLATLONGNAME FROM PSXLATITEM 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 PSXLATITEM I WHERE I.FIELDNAME = A.FIELDNAME AND I.FIELDVALUE = A.FIELDVALUE AND I.EFFDT <= %CurrentDateIn AND I.EFF_STATUS = 'A')

  • Related Language Record: PV_CPXLAT_RL_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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name