EOCM_CATVERP_VW

(SQL View)
 Index Back

Browse Prod Ent Partner

Browse Prod Enterprise Partner

SELECT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_CAT_VER_ID , B.EOCM_ACCESS_ID , B.EOCM_TP_VER_ID , C.EOCM_OFFER_ID , C.EOCM_OFFER_NM FROM PS_EOCM_CAT_VER A , PS_EOCM_TP_VER B , PS_EOCM_GEN_TBL C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.EOCM_ACCESS_ID = C.EOCM_ACCESS_ID AND B.EOCM_TP_VER_ID = C.EOCM_TP_VER_ID AND A.EOCM_CATVER_STATUS = 'P' AND B.EOCM_TP_VER_STATE = 'P' AND B.SETID = C.SETID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND C.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_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
5 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
6 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
7 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name