FO_CAN3H_FUN_VW

(SQL View)
 Index Back

Order search view


SELECT C.SETID , C.CUST_ID , A.BUSINESS_UNIT , A.SO_ID , B.SO_STATUS , A.FO_EVENT_LST , A.OWNERSHIP_ID FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CUSTOMER C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.REC_GROUP_ID = 'FS_23' AND SC.RECNAME = 'CUSTOMER') AND A.CUST_ID = C.CUST_ID AND A.SYSTEM_SOURCE = 'STF' AND EXISTS ( SELECT 'x' FROM PS_FO_EVENT_LS_HDR Z WHERE Z.FO_EVENT_LST = A.FO_EVENT_LST) AND B.SO_STATUS ='U'

  • Parent Record Of FO_CAN3L_FUN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: FO_CUST_AL_SRCH

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    4 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    5 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
    D=Draft
    E=Ended
    F=Filled
    U=Unfilled
    6 FO_EVENT_LST Character(30) VARCHAR2(30) NOT NULL Staffing Front Office Recruiting Funnel Event List
    7 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization