SUP_BID_2_SUP_V

(SQL View)
 Index Back

Strat Sourcing Bidder Header

Used to store Strat Sourcing Bidder Header info

SELECT A.SETID ,A.BIDDER_ID ,B.FIRST_NAME ,B.LAST_NAME ,B.FIRST_NAME %Concat ' ' %Concat B.LAST_NAME ,A.AUC_COMPANY_NAME ,B.ADDR_SEQ_NUM ,A.CREATEOPRID ,A.CREATE_DTTM ,A.LASTUPDOPRID ,A.LAST_UPDATE_DTTM FROM PS_AUC_BIDDER_HDR A , PS_AUC_CONTACT_HDR B ,PS_SUP_OB_REG_DEF C WHERE A.SETID = B.SETID AND A.BIDDER_ID =B.BIDDER_ID AND A.EFF_STATUS ='A' AND B.PRIMARY_FLG ='Y' AND A.BIDDER_ID = C.BIDDER_ID AND A.SUP_OB_REG_ID = C.SUP_OB_REG_ID AND C.SUPOB_REG_OPT_TYPE = 'NB' AND C.SUP_OB_APR_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_AUC_BIDDER_XREF D WHERE A.SETID = D.BIDDER_SETID AND A.BIDDER_ID = D.BIDDER_ID) UNION SELECT A.SETID ,A.BIDDER_ID ,B.FIRST_NAME ,B.LAST_NAME ,B.FIRST_NAME %Concat ' ' %Concat B.LAST_NAME ,A.AUC_COMPANY_NAME ,B.ADDR_SEQ_NUM ,A.CREATEOPRID ,A.CREATE_DTTM ,A.LASTUPDOPRID ,A.LAST_UPDATE_DTTM FROM PS_AUC_BIDDER_HDR A , PS_AUC_CONTACT_HDR B WHERE A.SETID = B.SETID AND A.BIDDER_ID =B.BIDDER_ID AND A.SUP_OB_REG_ID =' ' AND NOT EXISTS ( SELECT 'X' FROM PS_AUC_BIDDER_XREF D WHERE A.SETID = D.BIDDER_SETID AND A.BIDDER_ID = D.BIDDER_ID)

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

Prompt Table: SP_SETID_NONVW

2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
6 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID
7 ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
9 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.