CA_WC_BIEVT_LVW

(SQL View)
 Index Back

Language View

To be used in Workcenter Billing Events not processed exception

SELECT HDR.CONTRACT_NUM ,EVT.BILL_PLAN_ID ,EVT.EVENT_OCCURRENCE ,BPL.LANGUAGE_CD ,BPL.DESCR ,( SELECT NAME1 FROM PS_CUSTOMER_LANG CUST1 , PS_SET_CNTRL_GROUP GRP1 WHERE BP.BILL_TO_CUST_ID = CUST1.CUST_ID AND BP.BUSINESS_UNIT_BI = GRP1.SETCNTRLVALUE AND GRP1.REC_GROUP_ID = 'FS_23' AND GRP1.SETID = CUST1.SETID AND CUST1.LANGUAGE_CD = CUST.LANGUAGE_CD) ,CUST.NAME1 FROM PS_CA_CONTR_HDR HDR , PS_CUST_VW_LNG CUST , PS_SET_CNTRL_GROUP GRP , PS_CA_BILL_PLAN BP , PS_CA_BP_EVENTS EVT ,PS_CA_BILLPLN_LANG BPL WHERE CUST.LANGUAGE_CD = BPL.LANGUAGE_CD AND %Join(COMMON_KEYS, CA_BILL_PLAN BP, CA_BILLPLN_LANG BPL) AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID AND HDR.CA_RQST_SRC <> 'OND' AND HDR.CA_PROC_STATUS = 'A' AND HDR.CONTRACT_NUM = BP.CONTRACT_NUM AND BP.CONTRACT_NUM = EVT.CONTRACT_NUM AND BP.BILL_PLAN_ID = EVT.BILL_PLAN_ID AND BP.BP_STATUS IN ('RDY','PRG','RQD') AND EVT.BP_EVENT_STATUS IN ('PND', 'RCL','RDY') AND EVT.EVENT_DT <= %CurrentDateIn

  • Related Language Record for CA_WC_BIEVT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

    Prompt Table: CA_BILL_PLAN

    3 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1