GM_RATE_PLN_B_C

(SQL View)
 Index Back

Rate Plan Bill and Cost View


SELECT DISTINCT A.BUSINESS_UNIT , A.RATE_PLAN , B.DESCR FROM PS_GM_RATE_LN_SET A , PS_PC_RATE_PLAN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RATE_PLAN = B.RATE_PLAN AND (EXISTS ( SELECT 'X' FROM PS_GM_RATE_LN_SET B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RATE_PLAN = A.RATE_PLAN AND B.RATE_DEF_TYPE = 'B') AND EXISTS ( SELECT 'X' FROM PS_GM_RATE_LN_SET B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RATE_PLAN = A.RATE_PLAN AND B.RATE_DEF_TYPE = 'C') OR EXISTS ( SELECT 'X' FROM PS_GM_RATE_LN_SET B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RATE_PLAN = A.RATE_PLAN AND B.RATE_DEF_TYPE = 'M'))

  • Related Language Record: GM_RATE_PLN_LNG

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

    Prompt Table: SP_BU_PC_NONVW

    2 RATE_PLAN Character(15) VARCHAR2(15) NOT NULL Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description