GM_RLS_ADJ_VW(SQL View) |
Index Back |
---|---|
Distinct Roles with Adjustment |
SELECT DISTINCT A.BUSINESS_UNIT ,A.PROPOSAL_ID ,A.VERSION_ID ,B.BUSINESS_UNIT_PC ,A.SUB_PROP_NBR ,A.BUDGET_ID ,A.PROJ_ROLE ,A.ACTUAL_BILL_RATE ,A.ADJUST_OPTION_BILL ,0 FROM PS_GM_OPPTY_DTL_TM A ,PS_GM_BUD_HDR D ,PS_GM_PROP_PROJ B ,PS_GM_PROPOSAL C WHERE A.ADJUST_OPTION_BILL <> 'N' AND C.SUBMIT_STATUS = 'CMTD' AND C.PPSL_TO_CNTRCT_FLG IN ('N','P') AND C.CURRENT_VERSION = 'Y' AND D.PRICING_METHOD = 'INC' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROPOSAL_ID = D.PROPOSAL_ID AND A.VERSION_ID = D.VERSION_ID AND A.SUB_PROP_NBR = D.SUB_PROP_NBR AND A.BUDGET_ID = D.BUDGET_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.SUB_PROP_NBR = B.SUB_PROP_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROPOSAL_ID = C.PROPOSAL_ID AND A.VERSION_ID = C.VERSION_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
3 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
4 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
5 | SUB_PROP_NBR | Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
6 | BUDGET_ID | Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
7 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
8 | ACTUAL_BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Actual Bill Rate |
9 | ADJUST_OPTION_BILL | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Option Bill Rate
A=Flat Amount N=No Adjustment P=Percentage R=New Rate |
10 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |