RNW_PKG_IDTARGET_CONTRACTBUNDLE_OFFERINGCA_RNW_BUNDL_VW(SQL View) |
Index Back |
|---|---|
Renewals Bundle IdsView to fetch bundle ids available for target contract of a renewal cycle |
| SELECT PKG.RNW_PKG_ID , BUNDLE.CONTRACT_NUM , BUNDLE.BUNDLE_OFFERING FROM PS_CA_RNW_PKG PKG ,PS_CA_BUNDLE_VW BUNDLE WHERE PKG.TARGET_CONTRACT = BUNDLE.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RNW_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | PSIRS-KK |
| 2 | TARGET_CONTRACT |
Character(25) | VARCHAR2(25) NOT NULL | PSIRS-KK |
| 3 | BUNDLE_OFFERING |
Character(20) | VARCHAR2(20) NOT NULL | Bundle |