VIEW: APPS.GMD_QC_E_SUPP_SMPEVT_DTLS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'