View: GMD_QC_E_CUST_SAMPLE_DTLS_V

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

View Text

SELECT GSMP.SAMPLE_ID SAMPLE_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HROU.NAME OPERATING_UNIT_NAME
, HZCSUA.LOCATION SHIP_TO_SITE_NAME
, OEOHA.ORDER_NUMBER ORDER_NUMBER
, OETRTYP.NAME ORDER_TYPE
, OEOLA.LINE_NUMBER ORDER_LINE_NUMBER
FROM GMD_SAMPLES GSMP
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS_ALL HZCA
, HR_OPERATING_UNITS HROU
, HZ_CUST_SITE_USES_ALL HZCSUA
, OE_ORDER_HEADERS_ALL OEOHA
, OE_TRANSACTION_TYPES OETRTYP
, OE_ORDER_LINES_ALL OEOLA
WHERE HZP.PARTY_ID = HZCA.PARTY_ID
AND HZCA.CUST_ACCOUNT_ID = GSMP.CUST_ID
AND HROU.ORGANIZATION_ID(+) = GSMP.ORG_ID
AND HZCSUA.SITE_USE_ID(+) = GSMP.SHIP_TO_SITE_ID
AND OEOHA.HEADER_ID(+) = GSMP.ORDER_ID
AND OETRTYP.TRANSACTION_TYPE_ID(+) = OEOHA.ORDER_TYPE_ID
AND OEOLA.LINE_ID(+) = GSMP.ORDER_LINE_ID
AND GSMP.SOURCE = 'C'

Columns