View: POS_SUPP_PUB_HISTORY_V

Product:	POS - iSupplier Portal
Description:
Implementation/DBA Data:	APPS.POS_SUPP_PUB_HISTORY_V

View Text

SELECT SPH.PUBLICATION_EVENT_ID
, AP.VENDOR_ID
, AP.PARTY_ID
, HP.PARTY_NAME "SUPPLIER_NAME"
, HP.PARTY_NUMBER "REGISTRY_ID"
, AP.SEGMENT1 "SUPPLIER_NUMBER"
, SPH.PUBLICATION_DATE "PUBLICATION_DATE"
, SPH.PUBLISHED_BY "PUBLISHED_BY"
, FU.USER_NAME "PUBLISHED_BY_NAME"
, SPH.PUBLISH_DETAIL "PUBLISH_DETAIL"
, SPH.XMLCONTENT "XMLCONTENT"
, SPH.CREATED_BY
, SPH.CREATION_DATE
, SPH.LAST_UPDATED_BY
, SPH.LAST_UPDATE_DATE
, SPH.LAST_UPDATE_LOGIN
, SPH.REQUEST_ID "REQUEST_ID" FROM POS_SUPP_PUB_HISTORY SPH
, AP_SUPPLIERS AP
, HZ_PARTIES HP
, FND_USER FU WHERE AP.PARTY_ID = SPH.PARTY_ID AND HP.PARTY_ID = SPH.PARTY_ID AND FU.USER_ID = SPH.PUBLISHED_BY