FS_CUST_AL_LVW

(SQL View)
 Index Back

All Active Customers


SELECT DISTINCT B.SETID ,B.BUSINESS_UNIT , B.CUST_ID , B.CONVER_DTTM_INIT , B.CONVER_DT , B.LANGUAGE_CD , B.NAME1 , B.DESCR FROM PS_AR_CUST_AL_SRLW B , PS_CUST_CONVER_DTL A , PS_CUST_CONVER_DTL E , PS_CUST_CONVER_DTL F , PS_CUST_CONVER_DTL G , PS_CUST_CONVER_DTL H , PS_CUST_CONVER_DTL I , PS_CUST_CONVER_DTL J , PS_CUST_CONVER_DTL K WHERE B.SETID = A.SETID(+) AND B.CUST_ID = A.CUST_ID(+) AND B.CONVER_DTTM_INIT = A.CONVER_DTTM_INIT(+) AND A.CONVR_QUALIFIER_CD(+) = 'I' AND B.SETID = E.SETID(+) AND B.CONVER_DTTM_INIT = E.CONVER_DTTM_INIT(+) AND B.CUST_ID = E.CUST_ID(+) AND E.CONVR_QUALIFIER_CD(+) = 'BI' AND B.SETID = F.SETID (+) AND B.CONVER_DTTM_INIT = F.CONVER_DTTM_INIT (+) AND B.CUST_ID = F.CUST_ID (+) AND F.CONVR_QUALIFIER_CD(+) = 'CT' AND B.SETID = G.SETID (+) AND B.CONVER_DTTM_INIT = G.CONVER_DTTM_INIT (+) AND B.CUST_ID = G.CUST_ID (+) AND G.CONVR_QUALIFIER_CD(+) = 'D' AND B.SETID = H.SETID(+) AND B.CONVER_DTTM_INIT = H.CONVER_DTTM_INIT(+) AND B.CUST_ID = H.CUST_ID(+) AND H.CONVR_QUALIFIER_CD(+) = 'L' AND B.SETID = I.SETID(+) AND B.CONVER_DTTM_INIT = I.CONVER_DTTM_INIT(+) AND B.CUST_ID = I.CUST_ID(+) AND I.CONVR_QUALIFIER_CD(+) = 'P' AND B.SETID = J.SETID (+) AND B.CONVER_DTTM_INIT = J.CONVER_DTTM_INIT (+) AND B.CUST_ID = J.CUST_ID (+) AND J.CONVR_QUALIFIER_CD(+) = 'PY' AND B.SETID = K.SETID (+) AND B.CONVER_DTTM_INIT = K.CONVER_DTTM_INIT (+) AND B.CUST_ID = K.CUST_ID (+) AND K.CONVR_QUALIFIER_CD(+) = 'SO'

  • Related Language Record for FS_CUST_AL_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_AR_SET_NONVW

    3 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: CUST_ALL_VW

    4 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime

    Default Value: %datetime

    5 CONVER_DT Date(10) DATE Conversation Date
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description