SCP_SECAUC_PMPT

(SQL View)
Index Back

Bidder Pagelet View

Bidder Pagelet View

SELECT B.AUC_ID , B.AUC_NAME , B.BUSINESS_UNIT FROM PS_SCP_SEC_AUC_VW A , PS_AUC_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
2 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit