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

VIEW: APPS.AR_XML_INVOICE_REMIT_TO_V

Object Details
Object Name: AR_XML_INVOICE_REMIT_TO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_XML_INVOICE_REMIT_TO_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
CUST_ACCT_SITE_ID NUMBER (15) Yes
ADDRESS1 VARCHAR2 (240)
First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
ADDRESS VARCHAR2 (4000)
CITY VARCHAR2 (60)
COUNTY VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
TERRITORY_SHORT_NAME VARCHAR2 (80)
COMPLETE_ADDRESS VARCHAR2 (4000)
USER1 VARCHAR2 (4000)
USER2 VARCHAR2 (4000)
USER3 VARCHAR2 (4000)
USER4 VARCHAR2 (4000)
USER5 VARCHAR2 (4000)
Query Text

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


SELECT CUST_ACCT_SITE_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      TERRITORY_SHORT_NAME
,      COMPLETE_ADDRESS
,      USER1
,      USER2
,      USER3
,      USER4
,      USER5
FROM APPS.AR_XML_INVOICE_REMIT_TO_V;

Dependencies

[top of page]

APPS.AR_XML_INVOICE_REMIT_TO_V references the following:

SchemaAPPS
PL/SQL PackageARH_ADDR_PKG - show dependent code
PL/SQL PackageAR_XML_VIEW_FUNCTIONS - show dependent code
ViewFND_TERRITORIES_VL
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES

APPS.AR_XML_INVOICE_REMIT_TO_V is not referenced by any database object