SUP_OB_MORBS_VW

(SQL View)
 Index Back

Manage Obsolete Reg Bid Sup VW

Manage Obsolete Register Bidder/Supplier view

SELECT A.SETID , A.BIDDER_ID , A.SUP_OB_REG_ID , A.EFF_STATUS , B.SUP_OB_APR_STATUS , A.REASON_CD , A.EMAIL_FLG , A.EMAILID , A.BID_CONTACT_TYPE , A.AUC_COMPANY_NAME , A.ADDL_COMP_LBL , A.URL , B.SUP_INITIATED_BY , A.MAIN_ADDR_SEQ_NUM , A.BILL_ADDR_SEQ_NUM , A.SHIP_ADDR_SEQ_NUM , A.INV_ADDR_SEQ_NUM , A.CREATEOPRID , A.CREATE_DTTM , A.LASTUPDOPRID , A.LAST_UPDATE_DTTM , B.SUPOB_REG_OPT_TYPE , C.FIRST_NAME %Concat ' ' %Concat C.LAST_NAME , D.OPRDEFNDESC , CASE WHEN A.EMAILID <> ' ' THEN A.EMAILID ELSE D.EMAILID END FROM PS_SUP_OB_REG_DEF B , PS_AUC_BIDDER_HDR A LEFT OUTER JOIN PS_AUC_CONTACT_HDR C ON A.SETID = C.SETID AND A.BIDDER_ID = C.BIDDER_ID AND C.PRIMARY_FLG ='Y' LEFT OUTER JOIN PSOPRDEFN D ON A.LASTUPDOPRID = D.OPRID WHERE A.SETID = B.SETID AND A.BIDDER_ID =B.BIDDER_ID AND B.SUP_OB_APR_STATUS IN ('D','I','P','E','B','R','O','X','C','F')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 SUP_OB_APR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=OFAC Checked
A=Approved
B=Request Editor More Info..
C=Dup supplier checked
D=Draft
E=Pending Editor Review
F=Failed Dup supplier checking
I=Request More Information
P=Pending Approval
R=Rejected
W=Withdrawn
X=Failed OFAC Checking
6 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
7 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes
8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual
10 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID
11 ADDL_COMP_LBL Character(40) VARCHAR2(40) NOT NULL Additional Name
12 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
13 SUP_INITIATED_BY Character(2) VARCHAR2(2) NOT NULL Ordered by
BU=Buyer
EX=External
IN=Internal
14 MAIN_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
15 BILL_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
16 SHIP_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
17 INV_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
18 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
19 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
20 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.
21 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.
22 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
AD=Ad-hoc Tasks
NB=Register New Bidders
NS=Register New Suppliers
NU=Register New User Accounts
PC=Profile Change Request
RB=Request Change for Bidder
RS=Request Supplier Change
23 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
24 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
25 EMAILID2 Character(70) VARCHAR2(70) NOT NULL Email ID