CA_PPD_BP_VW_LG

(SQL View)
 Index Back

Prepaid Bill Plan View

Prompt view for Prepaid Bill plans

SELECT A.CONTRACT_NUM , A.BILL_PLAN_ID , D.LANGUAGE_CD , A.DESCR , B.NAME1 FROM PS_SET_CNTRL_REC C , PS_CUSTOMER B , PS_CA_BILL_PLAN A , PS_CA_BILLPLN_LANG D WHERE %Join(COMMON_KEYS, CA_BILLPLN_LANG D, CA_BILL_PLAN A) AND 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 for CA_PGP_BP_VW CA_PPD_BP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name