[Home] [Help] [Dependency Information]
Object Name: | GMI_AAC_CUST_NUM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.GMI_AAC_CUST_NUM_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
View Of Process Customers By Name and Number Including the Ship to site information, company and whse.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_NO | VARCHAR2 | (4000) | Unique identifier of a customer. | |
CUST_NAME | VARCHAR2 | (40) | Customer name | |
OF_SHIP_TO_SITE_USE_ID | NUMBER | Surrogate from Oracle Financials identifying the customer location. | ||
CO_CODE | VARCHAR2 | (4) | Yes | Company for which the customer number is defined. A NULL value indicates the customer is defined for all companies. |
WHSE_CODE | VARCHAR2 | (4) | Yes | Code for the warehouse. |
SHIP_IND | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_NO
, CUST_NAME
, OF_SHIP_TO_SITE_USE_ID
, CO_CODE
, WHSE_CODE
, SHIP_IND
FROM APPS.GMI_AAC_CUST_NUM_V;
APPS.GMI_AAC_CUST_NUM_V is not referenced by any database object
|
|
|