VIEW: APPS.GMD_QC_E_CUST_SAMPLE_DTLS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'