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

Object Details

Object Name:	CS_SR_HZ_CUST_CONT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_HZ_CUST_CONT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PARTY_ID	NUMBER	(15)	The party identifier of person or relation.
PARTY_NUMBER	VARCHAR2	(30)	The party number of person or relation.
PARTY_TYPE	VARCHAR2	(30)	The party type.
PARTY_NAME	VARCHAR2	(360)	The party name of person or relation.
PERSON_FIRST_NAME	VARCHAR2	(150)	The first name of person or relation.
PERSON_LAST_NAME	VARCHAR2	(150)	The last name of person or relation.
ACCOUNT_NUMBER	VARCHAR2	(30)	The party account number.
ACCOUNT_NAME	VARCHAR2	(240)	The party account name.
PARTY_TYPE_MEANING	VARCHAR2	(80)	The party type meaning.

Query Text

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


SELECT PARTY_ID
,      PARTY_NUMBER
,      PARTY_TYPE
,      PARTY_NAME
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
,      PARTY_TYPE_MEANING
FROM APPS.CS_SR_HZ_CUST_CONT_V;

Dependencies

[top of page]

APPS.CS_SR_HZ_CUST_CONT_V references the following:

APPS: CS_LOOKUPS; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CS_SR_HZ_CUST_CONT_V is referenced by following:

APPS: SR_UWQ_INTEG - show dependent code