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_V1

Object Details

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

View Type

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

Displays customer number and vendor number depending on the report type selected by the user

[View Source]

Columns

Name	Datatype	Length	Comments
CUST_VEND_NO	VARCHAR2	(4000)	Customer or Vendor number
CO_CODE	VARCHAR2	(4)	Company code
REPORT_TYPE	CHAR	(1)	Report type

Query Text

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


SELECT CUST_VEND_NO
,      CO_CODE
,      REPORT_TYPE
FROM APPS.GMD_CUST_VEND_MST_V1;

Dependencies

[top of page]

APPS.GMD_CUST_VEND_MST_V1 references the following:

APPS: FND_PROFILE - show dependent code; OP_CUST_MST; PO_VEND_MST

APPS.GMD_CUST_VEND_MST_V1 is not referenced by any database object