RO_SEARCH_LN_VW

(SQL View)
 Index Back

Search Line View

This record is a view used for search line

SELECT H.SYNCID , L.BUSINESS_UNIT , L.PRODUCT_ID , P.DESCR , L.RBTNUMBER , L.STATUS_CODE FROM PS_RO_HEADER H , PS_RO_LINE L , PS_PROD_ITEM P WHERE H.CAPTURE_ID = L.CAPTURE_ID AND L.PRODUCT_ID=P.PRODUCT_ID AND P.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = L.BUSINESS_UNIT AND S.RECNAME = 'PROD_ITEM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM
Set Control Field: BUSINESS_UNIT

4 PRODUCTDESCR Character(30) VARCHAR2(30) NOT NULL Description
5 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
6 STATUS_CODE_LINE Number(5,0) INTEGER NOT NULL Field used as number field for Status Code. Mostly used in correxpondance management

Prompt Table: RO_DEFN_LNST_VW