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.

[Home] [Help]

View: VEH_CUST_TP_V

Product:	VEH - Automotive Integration Kit (Obsolete)
Description:	- Retrofitted--Changed by NPARIKH on 07/24/1997 4:00 pm changed the select clause for EXTERNAL : Bug no. 517975
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RAC.CUSTOMER_NUMBER TP_CUST_ID
, RAC.CUSTOMER_NUMBER TP_CUST_NUMBER
, RAC.CUSTOMER_NAME TP_CUST_NAME
, 'INTERNAL' INT_EXT_CODE
FROM RA_CUSTOMERS RAC UNION SELECT DISTINCT TO_CHAR(ETG.TP_GROUP_ID) TP_CUST_ID
, ETG.TP_GROUP_CODE TP_CUST_NUMBER
, ETG.TP_GROUP_DESCRIPTION TP_CUST_NAME
, 'EXTERNAL' INT_EXT_CODE
FROM ECE_TP_DETAILS ETD
, ECE_TP_HEADERS ETH
, ECE_TP_GROUP ETG
WHERE ETD.TP_HEADER_ID = ETH.TP_HEADER_ID
AND ETH.TP_GROUP_ID = ETG.TP_GROUP_ID
AND ETD.DOCUMENT_TYPE IN ('C-SPS'
, 'C-SSS'
, 'C-PSQ'
, 'DSNO')

Columns

Name
TP_CUST_ID
TP_CUST_NUMBER
TP_CUST_NAME
INT_EXT_CODE