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