View: GMD_QC_E_SUPP_SMPEVT_DTLS_V

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V

View Text

SELECT GSMPEVT.SAMPLING_EVENT_ID SAMPLING_EVENT_ID
, POVEND.SEGMENT1 SUPPLIER_CODE
, POVEND.VENDOR_NAME SUPPLIER_NAME
, POVENDSITES.VENDOR_SITE_CODE SUPPLIER_SITE
, POHDRALL.SEGMENT1 PO_NUMBER
, POLINESALL.LINE_NUM PO_LINE_NUMBER
, RCVSHIPHDR.RECEIPT_NUM RECEIPT_NUMBER
, RCVSHIPLINES.LINE_NUM RECEIPT_LINE_NUMBER
, GSMPEVT.ORG_ID
FROM GMD_SAMPLING_EVENTS GSMPEVT
, PO_VENDORS POVEND
, PO_VENDOR_SITES_ALL POVENDSITES
, PO_HEADERS_ALL POHDRALL
, PO_LINES_ALL POLINESALL
, RCV_SHIPMENT_HEADERS RCVSHIPHDR
, RCV_SHIPMENT_LINES RCVSHIPLINES
WHERE GSMPEVT.SUPPLIER_ID = POVEND.VENDOR_ID
AND GSMPEVT.SUPPLIER_SITE_ID = POVENDSITES.VENDOR_SITE_ID(+)
AND GSMPEVT.PO_HEADER_ID = POHDRALL.PO_HEADER_ID(+)
AND GSMPEVT.PO_LINE_ID = POLINESALL.PO_LINE_ID(+)
AND GSMPEVT.RECEIPT_ID = RCVSHIPHDR.SHIPMENT_HEADER_ID(+)
AND GSMPEVT.RECEIPT_LINE_ID = RCVSHIPLINES.SHIPMENT_LINE_ID(+)
AND GSMPEVT.SOURCE = 'S'

Columns