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.CLN_PROCAT_CUSTOMER_V

Object Details

Object Name:	CLN_PROCAT_CUSTOMER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_PROCAT_CUSTOMER_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View of the recipient of the price list

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_NAME	VARCHAR2	(360)	Yes	Customer description.
PARTY_ID	NUMBER		Yes	Customer ID in XML Gateway.
PARTY_SITE_ID	NUMBER		Yes
CUSTOMER_PARTNRIDX	VARCHAR2	(200)		Customer EDI Location Code.

Query Text

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


SELECT PARTY_NAME
,      PARTY_ID
,      PARTY_SITE_ID
,      CUSTOMER_PARTNRIDX
FROM APPS.CLN_PROCAT_CUSTOMER_V;

Dependencies

[top of page]

APPS.CLN_PROCAT_CUSTOMER_V references the following:

APPS: ECX_EXT_PROCESSES; ECX_TP_DETAILS; ECX_TP_HEADERS; ECX_TRANSACTIONS; HZ_PARTIES

APPS.CLN_PROCAT_CUSTOMER_V is not referenced by any database object