VIEW: APPS.GMD_QC_E_CUST_SMPEVT_DTLS_V

Source

View Text - Preformatted

SELECT gsmpevt.sampling_event_id sampling_event_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_sampling_events gsmpevt ,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 = gsmpevt.cust_id AND hrou.organization_id(+) = gsmpevt.org_id AND hzcsua.site_use_id(+) = gsmpevt.ship_to_site_id AND oeoha.header_id(+) = gsmpevt.order_id AND oetrtyp.transaction_type_id(+) = oeoha.order_type_id AND oeola.line_id(+) = gsmpevt.order_line_id AND gsmpevt.SOURCE = 'C'

View Text - HTML Formatted

SELECT GSMPEVT.SAMPLING_EVENT_ID SAMPLING_EVENT_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_SAMPLING_EVENTS GSMPEVT
, 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 = GSMPEVT.CUST_ID
AND HROU.ORGANIZATION_ID(+) = GSMPEVT.ORG_ID
AND HZCSUA.SITE_USE_ID(+) = GSMPEVT.SHIP_TO_SITE_ID
AND OEOHA.HEADER_ID(+) = GSMPEVT.ORDER_ID
AND OETRTYP.TRANSACTION_TYPE_ID(+) = OEOHA.ORDER_TYPE_ID
AND OEOLA.LINE_ID(+) = GSMPEVT.ORDER_LINE_ID
AND GSMPEVT.SOURCE = 'C'