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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.GMD_CUST_VEND_MST_V2

Object Details

Object Name:	GMD_CUST_VEND_MST_V2
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_CUST_VEND_MST_V2
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of customer and vendors for value set of Customer/Vendor Test Result report

[View Source]

Columns

Name	Datatype	Length	Comments
CUST_VEND_NO	VARCHAR2	(30)	Cust/Vendor Number
CUST_VEND_NAME	VARCHAR2	(360)	Cust/Vendor Name
CUST_VEND_ID	NUMBER		Cust/Vendor Id
REPORT_TYPE	CHAR	(1)	0- Customer 1- Vendor

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUST_VEND_NO
,      CUST_VEND_NAME
,      CUST_VEND_ID
,      REPORT_TYPE
FROM APPS.GMD_CUST_VEND_MST_V2;

Dependencies

[top of page]

APPS.GMD_CUST_VEND_MST_V2 references the following:

APPS: HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS_ALL; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; PO_VENDORS

APPS.GMD_CUST_VEND_MST_V2 is not referenced by any database object