EOCM_SOFF_VW

(SQL View)
 Index Back

Supp Offer View for Browse

Supplier Offering View used in the Browse Stage Offering pages.

SELECT DISTINCT A.SETID , A.EOCM_CATALOG_ID , C.EOCM_CAT_VER_ID , A.EOCM_OFFER_ID , B.EOCM_ACCESS_ID , B.EFFDT , C.EOCM_CATVER_STATUS , A.EOCM_OFFER_NM , B.EOCM_SUP_OFFER_NM , B.EFF_STATUS , D.EOCM_OFFER_STATUS FROM PS_EOCM_OFFER_TBL A , PS_EOCM_S_OFF_TBL B , PS_EOCM_CAT_VER C , PS_EOCM_GEN_TBL D WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_OFFER_ID = B.EOCM_OFFER_ID AND B.SETID = C.SETID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND C.EOCM_CATVER_STATUS = 'C' AND B.SETID = D.SETID AND B.EOCM_CATALOG_ID = D.EOCM_CATALOG_ID AND B.EOCM_OFFER_ID = D.EOCM_OFFER_ID AND D.EOCM_OFFER_STATUS = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id
4 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
5 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 EOCM_CATVER_STATUS Character(1) VARCHAR2(1) NOT NULL Catalog version Status
C=Current
P=Production
R=Retired
8 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name
9 EOCM_SUP_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
11 EOCM_OFFER_STATUS Character(1) VARCHAR2(1) NOT NULL Offering Status
C=Categorized
E=Error
L=Loaded
N=Rejected
S=Staged