DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.GMI_AAC_CUST_NUM_V

Object Details
Object Name: GMI_AAC_CUST_NUM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.GMI_AAC_CUST_NUM_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

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.


[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.GMI_AAC_CUST_NUM_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymIC_WHSE_MST
SynonymOP_CUST_MST
SynonymSY_ORGN_MST

APPS.GMI_AAC_CUST_NUM_V is not referenced by any database object