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

Object Details

Object Name:	CSL_HZ_CUST_ACCT_SITES_ALL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Mobile view on HZ_CUST_ACCT_SITES_ALL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			Indentifier to CSL_HZ_CUST_ACCT_SITES_ALL_ACC
CUST_ACCT_SITE_ID	NUMBER	(15)	Yes	Customer site identifier
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table
PARTY_SITE_ID	NUMBER	(15)	Yes	Identifier for a party site. Foreign key to the HZ_PARTY_SITES table
ORG_ID	NUMBER	(15)		Operating unit identifier
STATUS	VARCHAR2	(1)	Yes	Customer Status flag. Receivables lookup code for CODE_STATUS
BILL_TO_FLAG	VARCHAR2	(1)		Indicates if this is a Bill-To site. Y for a Bill-To site, P for the primary Bill-To site, and N for a site that is not a Bill-To site.
SHIP_TO_FLAG	VARCHAR2	(1)		Indicates if this is a Ship-To site. Y for a Ship-To site, P for the primary Ship-To site, and N for a site that is not a Ship-To site.
CUSTOMER_CATEGORY_CODE	VARCHAR2	(30)		User-definable category. The lookup type is CUSTOMER_CATEGORY.
LANGUAGE	VARCHAR2	(4)		Operating language of customer site. Foreign key to the FND_LANGUAGES table
KEY_ACCOUNT_FLAG	VARCHAR2	(1)		Key account for sales representatives
TRANSLATED_CUSTOMER_NAME	VARCHAR2	(50)		Translated customer name
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes

Query Text

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


SELECT ACCESS_ID
,      CUST_ACCT_SITE_ID
,      CUST_ACCOUNT_ID
,      PARTY_SITE_ID
,      ORG_ID
,      STATUS
,      BILL_TO_FLAG
,      SHIP_TO_FLAG
,      CUSTOMER_CATEGORY_CODE
,      LANGUAGE
,      KEY_ACCOUNT_FLAG
,      TRANSLATED_CUSTOMER_NAME
,      OBJECT_VERSION_NUMBER
FROM APPS.CSL_HZ_CUST_ACCT_SITES_ALL_V;

Dependencies

[top of page]

APPS.CSL_HZ_CUST_ACCT_SITES_ALL_V references the following:

APPS: ASG_BASE - show dependent code; CSL_HZ_CUST_ACCT_SITES_ALL_ACC; HZ_CUST_ACCT_SITES_ALL

APPS.CSL_HZ_CUST_ACCT_SITES_ALL_V is not referenced by any database object