[Home] [Help]
View: GMD_QC_E_SUPP_SAMPLE_DTLS_V
View Text
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
Columns
Name |
SAMPLE_ID |
SUPPLIER_CODE |
SUPPLIER_NAME |
SUPPLIER_SITE |
PO_NUMBER |
PO_LINE_NUMBER |
RECEIPT_NUMBER |
RECEIPT_LINE_NUMBER |
SUPPLIER_OPERATING_UNIT |
ORGANIZATION_ID |
ORGANIZATION_CODE |