eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMD_QC_E_SUPP_SAMPLE_DTLS_V

Source

View Text - Preformatted


SELECT gsmp.sample_id sample_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 ,hrops.name supplier_operating_unit ,gsmp.organization_id ,mp.organization_code FROM gmd_samples gsmp ,po_vendors povend ,po_vendor_sites_all povendsites ,po_headers_all pohdrall ,po_lines_all polinesall ,rcv_shipment_headers rcvshiphdr ,rcv_shipment_lines rcvshiplines ,hr_operating_units hrops ,mtl_parameters mp WHERE gsmp.supplier_id = povend.vendor_id AND gsmp.supplier_site_id = povendsites.vendor_site_id(+) AND gsmp.po_header_id = pohdrall.po_header_id(+) AND gsmp.po_line_id = polinesall.po_line_id(+) AND gsmp.receipt_id = rcvshiphdr.shipment_header_id(+) AND gsmp.receipt_line_id = rcvshiplines.shipment_line_id(+) AND gsmp.SOURCE = 'S' AND hrops.organization_id = gsmp.org_id AND mp.organization_id = gsmp.organization_id

View Text - HTML Formatted

SELECT GSMP.SAMPLE_ID SAMPLE_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
, HROPS.NAME SUPPLIER_OPERATING_UNIT
, GSMP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
FROM GMD_SAMPLES GSMP
, PO_VENDORS POVEND
, PO_VENDOR_SITES_ALL POVENDSITES
, PO_HEADERS_ALL POHDRALL
, PO_LINES_ALL POLINESALL
, RCV_SHIPMENT_HEADERS RCVSHIPHDR
, RCV_SHIPMENT_LINES RCVSHIPLINES
, HR_OPERATING_UNITS HROPS
, MTL_PARAMETERS MP
WHERE GSMP.SUPPLIER_ID = POVEND.VENDOR_ID
AND GSMP.SUPPLIER_SITE_ID = POVENDSITES.VENDOR_SITE_ID(+)
AND GSMP.PO_HEADER_ID = POHDRALL.PO_HEADER_ID(+)
AND GSMP.PO_LINE_ID = POLINESALL.PO_LINE_ID(+)
AND GSMP.RECEIPT_ID = RCVSHIPHDR.SHIPMENT_HEADER_ID(+)
AND GSMP.RECEIPT_LINE_ID = RCVSHIPLINES.SHIPMENT_LINE_ID(+)
AND GSMP.SOURCE = 'S'
AND HROPS.ORGANIZATION_ID = GSMP.ORG_ID
AND MP.ORGANIZATION_ID = GSMP.ORGANIZATION_ID