RS_XS_SOORGUNIT

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE ,%TrimSubstr(A.BUSINESS_UNIT, 1, 5) %Concat '' %Concat %TrimSubstr(A.SO_ID, 1, 15) %Concat '' %Concat %TrimSubstr(%NumToChar(A.SO_LINE), 1, 3) AS SOID , %TrimSubstr(B.SETID, 1, 5) %Concat 'x' %Concat %TrimSubstr(B.NODE_NAME , 1, 40) %Concat 'x' %Concat B.NODE_DETAIL AS SOOU ,B.SETID ,B.NODE_DETAIL ,B.NODE_NAME FROM PS_RS_SO_LINE A , PS_RS_SO_ORG B , PS_RS_SO_HDR C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SO_ID = C.SO_ID AND A.SO_LINE_STATUS = 'O' AND A.SO_ID IN ( SELECT SO_ID FROM PS_RS_SO_STAT_VW1 WHERE BUSINESS_UNIT = A.BUSINESS_UNIT) AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SO_ID = C.SO_ID AND B.SETID = C.TREE_SETID AND C.SYSTEM_SOURCE = 'RS' GROUP BY A.BUSINESS_UNIT, A.SO_ID, A.SO_LINE,B.BUSINESS_UNIT ,B.SO_ID ,B.SETID ,B.NODE_DETAIL ,B.NODE_NAME

# 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 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key
5 SOOU Character(48) VARCHAR2(48) NOT NULL Service Order Org Unit
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
D=Detail
N=Node
8 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name