CA_PPD_BP_VW

(SQL View)
 Index Back

Prepaid Bill Plan View

Prompt view for Prepaid Bill plans

SELECT A.CONTRACT_NUM , A.BILL_PLAN_ID , A.BILL_PLAN_TYPE , A.DESCR , A.BILL_TO_CUST_ID , B.NAME1 FROM PS_SET_CNTRL_REC C , PS_CUSTOMER B , PS_CA_BILL_PLAN A WHERE C.RECNAME = 'CUSTOMER' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT_BI AND B.SETID = C.SETID AND A.BILL_TO_CUST_ID = B.CUST_ID AND A.BP_STATUS = 'PND' AND A.BILL_PLAN_TYPE IN ('04','05','06') AND NOT EXISTS ( SELECT 1 FROM PS_CA_BP_LINES L WHERE A.CONTRACT_NUM = L.CONTRACT_NUM AND A.BILL_PLAN_ID = L.BILL_PLAN_ID AND L.CA_PGP_SEQ > 0)

  • Related Language Record: CA_PPD_BP_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CONTR_HDR

    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

    Prompt Table: CA_BILL_PLAN

    3 BILL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Method
    01=As Incurred
    02=Installment
    03=Recurring
    04=Milestone
    05=Percent Complete
    06=Immediate
    07=Value Based
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name