[Home] [Help] [Dependency Information]
Object Name: | CSL_HZ_CUST_ACCT_SITES_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Mobile view on HZ_CUST_ACCT_SITES_ALL
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 |
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;
APPS.CSL_HZ_CUST_ACCT_SITES_ALL_V is not referenced by any database object
|
|
|