[Home] [Help] [Dependency Information]
Object Name: | CSL_HZ_CUST_SITE_USES_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_SITE_USES_ALL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Indentifier to CSL_HZ_CUST_SITE_USES_ALL_ACC | ||
SITE_USE_ID | NUMBER | (15) | Yes | Site use identifier |
CUST_ACCT_SITE_ID | NUMBER | (15) | Yes | Identifier for the customer account site. Foreign key to the HZ_CUST_ACCT_SITES_ALL table |
SITE_USE_CODE | VARCHAR2 | (30) | Yes | Business purpose assigned to customer site account, such as Bill-To, Market, and Statements. |
PRIMARY_FLAG | VARCHAR2 | (1) | Yes | Indicates if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites. |
STATUS | VARCHAR2 | (1) | Yes | Site use status flag, Lookup code for the CODE_STATUS column. |
LOCATION | VARCHAR2 | (40) | Yes | Site use identifier |
CONTACT_ID | NUMBER | (15) | Contact identifier | |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill-To site use identifier | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Site use identifier from foreign or legacy system | |
SIC_CODE | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
PAYMENT_TERM_ID | NUMBER | (15) | Payment term identifier | |
GSA_INDICATOR | VARCHAR2 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | |
SHIP_PARTIAL | VARCHAR2 | (1) | No longer used | |
SHIP_VIA | VARCHAR2 | (30) | The name of the preferred ship method. | |
FOB_POINT | VARCHAR2 | (30) | The name of the preferred ship method. | |
ORDER_TYPE_ID | NUMBER | (15) | Order type identifier | |
PRICE_LIST_ID | NUMBER | (15) | Price list identifier | |
FREIGHT_TERM | VARCHAR2 | (30) | Order Management lookup code for FREIGHT_TERMS | |
WAREHOUSE_ID | NUMBER | (15) | Warehouse identifier | |
TERRITORY_ID | NUMBER | (15) | Territory identifier | |
RESOURCE_ID | NUMBER | Yes | Mobile resource ID, referenced to CSL_HZ_CUST_SITE_USES_ALL_ACC |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, SITE_USE_ID
, CUST_ACCT_SITE_ID
, SITE_USE_CODE
, PRIMARY_FLAG
, STATUS
, LOCATION
, CONTACT_ID
, BILL_TO_SITE_USE_ID
, ORIG_SYSTEM_REFERENCE
, SIC_CODE
, PAYMENT_TERM_ID
, GSA_INDICATOR
, SHIP_PARTIAL
, SHIP_VIA
, FOB_POINT
, ORDER_TYPE_ID
, PRICE_LIST_ID
, FREIGHT_TERM
, WAREHOUSE_ID
, TERRITORY_ID
, RESOURCE_ID
FROM APPS.CSL_HZ_CUST_SITE_USES_ALL_V;
APPS.CSL_HZ_CUST_SITE_USES_ALL_V is not referenced by any database object
|
|
|