BUSINESS_UNITDefault Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
Set Control Field: BUSINESS_UNIT
PROPOSAL_IDPrompt Table: GM_PROP_ID_VW
VERSION_IDPrompt Table: CA_CNTR_SRCH_VW
GM_AWD_NEG_VW(SQL View) |
Index Back |
|---|---|
Grants Award SearchUsed to select records to PC_CONTRACT for Award setup. |
| SELECT A. BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , B.CONTRACT_NUM FROM PS_GM_PROPOSAL A , PS_GM_AWARD B WHERE A. BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID |
| # | 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_PC.BUSINESS_UNIT Prompt Table:
SP_BU_PC_NONVW
|
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |