CA_AMND_SRCH_VW

(SQL View)
 Index Back

Contract Header Search View

This is the Self-Service iClient version of the Contract Header Search View.

SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , CHG.CHG_ID , HDR.SOLD_TO_CUST_ID , CUST.NAME1 , HDR.CA_STATUS , CHG.CHG_STATUS , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CUST_SLD_VW CUST , PS_CA_CHG_HDR CHG , PS_SET_CNTRL_GROUP GRP WHERE HDR.CONTRACT_NUM = CHG.CONTRACT_NUM AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID AND CHG.CHG_ID <> '0000000000'

# 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_CNTR_SRCH_VW

3 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status

Prompt Table: CA_STATUS_VW

7 CHG_STATUS Character(1) VARCHAR2(1) NOT NULL Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied.
C=Complete
P=Pending
R=Ready
X=Cancelled
8 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW