RNW_PKG_IDCA_RNW_PKG_R_VW(SQL View) |
Index Back |
|---|---|
Renewal Plan View |
| SELECT A.RNW_PKG_ID , A.CURRENT_CYCLE_NBR , A.DESCR , A.BUSINESS_UNIT , A.TARGET_CONTRACT , C.SOLD_TO_CUST_ID FROM PS_CA_RNW_PKG A , PS_CA_RNW_CYCLE B , PS_CA_CONTR_HDR C WHERE A.RNW_PKG_STATUS IN ('PND', 'PRG') AND A.RNW_PKG_ID = B.RNW_PKG_ID AND A.CURRENT_CYCLE_NBR = B.RNW_CYCLE_NBR AND A.TARGET_CONTRACT = C.CONTRACT_NUM AND B.RNW_CYCLE_STATUS <> 'DON' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RNW_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | PSIRS-KK |
| 2 | RNW_CYCLE_NBR | Number(6,0) | INTEGER NOT NULL | PSIRS-KK |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | TARGET_CONTRACT | Character(25) | VARCHAR2(25) NOT NULL | PSIRS-KK |
| 6 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |