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

VIEW: APPS.ARFV_LOCATIONS

Object Details
Object Name: ARFV_LOCATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARFV_LOCATIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
ADDRESS_ID NUMBER (15) Yes
_LA:STATUS CHAR (47)
STREET_ADDRESS VARCHAR2 (963)
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTRY VARCHAR2 (80)
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (240) Yes
EDI_LOCATION VARCHAR2 (40)
_LA:PRIMARY_BILL_TO_FLAG CHAR (77)
OPERATING_UNIT VARCHAR2 (240)
CUSTOMER_NAME VARCHAR2 (50)
TERRITORY_NAME VARCHAR2 (40)
ORG_ID NUMBER (15)
CUSTOMER_ID NUMBER (15) Yes
LOCATION_ID NUMBER

TERROTORY_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT ADDRESS_ID
,      _LA:STATUS
,      STREET_ADDRESS
,      CITY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTRY
,      ORIGINAL_SYSTEM_REFERENCE
,      EDI_LOCATION
,      _LA:PRIMARY_BILL_TO_FLAG
,      OPERATING_UNIT
,      CUSTOMER_NAME
,      TERRITORY_NAME
,      ORG_ID
,      CUSTOMER_ID
,      LOCATION_ID
,      TERROTORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARFV_LOCATIONS;

Dependencies

[top of page]

APPS.ARFV_LOCATIONS references the following:

SchemaAPPS
ViewFND_TERRITORIES_VL
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_LOCATIONS
SynonymHZ_LOC_ASSIGNMENTS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymRA_TERRITORIES

APPS.ARFV_LOCATIONS is not referenced by any database object