CA_BP_SEARCH_VW

(SQL View)
 Index Back

Bill Plan Search Dialogue

Master contracts are excluded from this view.

SELECT HDR.BUSINESS_UNIT , BP.CONTRACT_NUM , BP.BILL_PLAN_ID , BP.BP_STATUS , HDR.CONTRACT_ADMIN FROM PS_CA_BILL_PLAN BP , PS_CA_CONTR_HDR HDR WHERE BP.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.CONTR_MSTR_FLG <> 'Y' AND HDR.CA_RQST_SRC <> 'OND'

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

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_NO_MSTR_VW

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

Default Value: NEXT

4 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
5 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW