RS_OPT_RR_VW

(SQL View)
 Index Back

SELECT %Sql(RS_FRAG_RR_KEY_SELECT, AC) , AC.START_DT , AC.END_DT , AC.EST_DAYS , AC.QTY_INTEGER , A.BUSINESS_UNIT_HR , A.TREE_SETID , A.NODE_DETAIL , A.OWNERSHIP_ID , AC.PART_TIME_FLG FROM %Table(RS_SO_HDR) A , %Table(RS_SO_STATUS) B , %Table(RS_SO_LINE) AC WHERE A.EXPRESS_SEARCH_FLG = 'N' AND A.SYSTEM_SOURCE='RS' AND %Join(COMMON_KEYS, RS_SO_STATUS B, RS_SO_HDR A) AND B.LASTUPDDTTM = ( SELECT MAX(AA.LASTUPDDTTM) FROM %Table(RS_SO_STATUS) AA WHERE %Join(COMMON_KEYS, RS_SO_STATUS AA, RS_SO_HDR A) ) AND B.SO_STATUS NOT IN ('C', 'X') AND %Join(COMMON_KEYS, RS_SO_LINE AC, RS_SO_HDR A) AND AC.SO_LINE_STATUS NOT IN ('A', 'C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
4 START_DT Date(10) DATE Start Date
5 END_DT Date(10) DATE End Date
6 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days
7 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
8 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
9 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
10 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
D=Detail
N=Node
11 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
12 PART_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Part Time