RPC_PRDBILL_VW

(SQL View)
 Index Back

Telco base object for CI

View used to retrieve billing options for each product.

SELECT A.SETID , A.PRODUCT_ID , A2.RBT_PURPOSE_ID , A2.NO , (CASE WHEN A2.PRIMARY_FLAG = 'Y' THEN 'Y' ELSE 'N' END) , A2.RBT_ACCOUNT_TYPE , D.XLATLONGNAME ,(CASE WHEN A2.REQUIRED_FLAG = 'Y' THEN 'Y' ELSE 'N' END) , A2.RBT_PURPOSE_DESCR FROM PS_PROD_ITEM a , PS_RBT_PROD_DTL A2 , PS_PROD_MLPB_ITEM b , PS_RB_HLEV_DFN_TBL c , PSXLATITEM d , PS_RB_MLPB_STRUCT e , PS_RBT_PROD_ITEM f WHERE a.SETID = b.SETID AND a.PRODUCT_ID = b.PRODUCT_ID AND a.SETID = A2.SETID AND a.PRODUCT_ID = A2.PRODUCT_ID AND a.SETID = f.SETID AND a.PRODUCT_ID = f.PRODUCT_ID AND f.RBT_ACCOUNT_SEL = 'Y' AND a.EFF_STATUS = 'A' AND a.CFG_KIT_FLAG = 'M' AND a.SETID = e.SETID AND e.STRUCTURE_ID = c.STRUCTURE_ID AND b.RB_HLEV_ID = c.RB_HLEV_ID AND d.FIELDNAME = 'RBT_ACCOUNT_TYPE' AND A2.RBT_ACCOUNT_TYPE = d.FIELDVALUE AND d.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
3 RBT_PURPOSE_ID Character(10) VARCHAR2(10) NOT NULL Field used for storing Billing Account Purpose ID
4 NO Number(2,0) SMALLINT NOT NULL Field used for storing Billing Account Details sequence number
5 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary

Y/N Table Edit

6 RBT_ACCOUNT_TYPE Character(2) VARCHAR2(2) NOT NULL Field to indicate what billing account can be used with this service.
EI=Either
PO=Postpaid Only
PP=Prepaid Only
7 ACCT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Field used for storing Account type description
8 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required
N=No
Y=Yes

Y/N Table Edit

9 RBT_PURPOSE_DESCR Character(254) VARCHAR2(254) NOT NULL Field used for storing Billing Account Purpose