FO_REPL_DTL_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , C.SO_LINE , A.OWNERSHIP_ID , A.USER_ORDER_TYPE , B.ASSIGNMENT_ID , B.REPLACED_ASGN_ID , B.REPLACED_BY , B.REPLACEMENT_STS , B.REPLAC_REQUEST_DT , B.REPLAC_START_DT FROM PS_RS_SO_HDR A , PS_RS_ASSIGNMENT B , PS_RS_SO_LINE C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SO_ID = C.SO_ID AND C.SO_LINE = B.SO_LINE AND A.SO_ID = B.SO_ID AND A.SYSTEM_SOURCE = 'STF'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
4 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
5 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type

Prompt Table: FO_ORDER_TYPE

6 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
7 REPLACED_ASGN_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Prompt Table: FO_ASGN_SRC_VW2

8 REPLACED_BY Character(15) VARCHAR2(15) NOT NULL Replaced By
9 REPLACEMENT_STS Character(1) VARCHAR2(1) NOT NULL Replacement Status
P=Pending Replacement
R=Replaced
10 REPLAC_REQUEST_DT Date(10) DATE Request Date
11 REPLAC_START_DT Date(10) DATE Request Date