EOEP_ARBACT_LVW

(SQL View)
 Index Back

Arb Plan Action Type by Trans

Arb Plan Action Type by Trans

SELECT D.EOEP_APP_CD , %Substring(FIELDVALUE , 1 , 2) , X.EFFDT , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEMLANG X WHERE D.EOEP_APP_CD_FIELD = 'ACTION_TYPE' AND X.FIELDNAME = 'EOEP_ARB_ACTN_TYPE' AND ( (D.EOEP_TRANS_VALUE = '1' AND X.FIELDVALUE IN ('1','2')) OR (D.EOEP_TRANS_VALUE = '2' AND X.FIELDVALUE = '3') OR (D.EOEP_TRANS_VALUE = '3' AND X.FIELDVALUE = '4') OR (D.EOEP_TRANS_VALUE = '4' AND X.FIELDVALUE IN ('5','6','7','8')) )

  • Related Language Record for EOEP_ARBACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
    2 EOEP_ARB_ACTN_TYPE Character(2) VARCHAR2(2) NOT NULL Price Action Type
    1=Discount
    2=Surcharge
    3=Price Override
    4=Giveaway / Product Add
    5=Total Order Discount
    6=Total Order Surcharge
    7=Product Add
    8=Free Period Promotion
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name