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
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
|
|
|