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_ITEMMST_CUSTOMER_V

Object Details

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

View Type

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

View for the customer section of the Sync Item XML message

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_NAME	VARCHAR2	(360)	Yes	Customer Name.
PARTY_ID	NUMBER		Yes	Customer Party ID.
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
,      CUSTOMER_PARTNRIDX
FROM APPS.CLN_ITEMMST_CUSTOMER_V;

Dependencies

[top of page]

APPS.CLN_ITEMMST_CUSTOMER_V references the following:

APPS: ECX_EXT_PROCESSES; ECX_TP_DETAILS; ECX_TP_HEADERS; ECX_TRANSACTIONS; HZ_PARTIES

APPS.CLN_ITEMMST_CUSTOMER_V is not referenced by any database object