RNW_PKG_IDPrompt Table: CA_BUS_UNIT_VW
Prompt Table: CUST_SLD_VW
DON=Done
PND=Pending
RDY=Ready
CA_RNW_PKG_VW(SQL View) |
Index Back |
|---|---|
CA-View of Rnw Pkg to Link ToPSIRS-KK This view identifies the Current Process Cycle for all Pending/In Progress Renewal Packages. The view is used on the Renewal Management panel to indicate which Renewal Cycle to link a Contract line to. Because of this, the Current Process Cycle must have a Cycle Status = Pending. |
| SELECT A.RNW_PKG_ID , A.CURRENT_CYCLE_NBR , A.DESCR , A.BUSINESS_UNIT , A.TARGET_CONTRACT , C.SOLD_TO_CUST_ID , B.RNW_CYCLE_STATUS 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 = 'PND' |
| # | 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
Prompt Table: CA_BUS_UNIT_VW |
| 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
Prompt Table: CUST_SLD_VW |
| 7 | RNW_CYCLE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
PSIRS-KK
DON=Done PND=Pending RDY=Ready |