PC_BUD_ID_KK

(SQL View)
 Index Back

Review Commitment Control

Review Commitment control Exceptions from INTFC_PROJ_RES

SELECT DISTINCT A.PC_BUDGET_ID , B.DESCR FROM PS_INTFC_PROJ_RES A , PS_PC_BUD_PLAN B WHERE A.KK_DISTRIB_STATUS IN ('E', 'S', 'B', 'C', 'N', ' ') AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID

  • Related Language Record: BUD_ID_KK_LNG

  • Parent Record Of BUD_ID_KK_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID

    Default Value: 1

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description