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


VIEW: APPS.JAI_CMN_CUST_ADDRESS_V

Object Details
Object Name: JAI_CMN_CUST_ADDRESS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_CMN_CUST_ADDRESS_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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
CUSTOMER_ID NUMBER

ATTRIBUTE1 VARCHAR2 (12)
ORGANIZATION_ID NUMBER

OPERATING_UNIT NUMBER

Query Text

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


SELECT ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      CUSTOMER_ID
,      ATTRIBUTE1
,      ORGANIZATION_ID
,      OPERATING_UNIT
FROM APPS.JAI_CMN_CUST_ADDRESS_V;

Dependencies

[top of page]

APPS.JAI_CMN_CUST_ADDRESS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymJAI_CMN_CUS_ADDRESSES
SynonymJAI_CMN_INVENTORY_ORGS

APPS.JAI_CMN_CUST_ADDRESS_V is not referenced by any database object