RFM_SO_LINE_VW

(SQL View)
 Index Back

Service Order Line View

Service Order Line View for displaying activities associated with the line in a prompt on mobile.

SELECT A.SYNCID , %Substring((CASE WHEN B.DESCR80 IS NOT NULL THEN %NumtoChar(A.SO_LINE) %Concat ' - ' %Concat B.DESCR80 ELSE %NumtoChar(A.SO_LINE) %Concat ' - ' %Concat SVC.DESCR80 END) , 1 , 80) , A.SYNCID , A.SYNCDTTM FROM PS_RF_SO_LINE A , PS_RF_ACTCODE_VW B , PS_RF_SO_HDR SO , PS_SET_CNTRL_REC S , PS_RF_SERVICE SVC WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE(+) AND A.ACTIVITY_CODE = B.ACTIVITY_CODE(+) AND A.BUSINESS_UNIT = SO.BUSINESS_UNIT AND A.SO_ID = SO.SO_ID AND A.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.RECNAME = 'RF_SERVICE' AND S.SETID = SVC.SETID AND SO.SERVICE_ID = SVC.SERVICE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SO_LINE_OID Signed Number(11,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
3 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
4 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time