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

VIEW: APPS.AS_L_SITES_ACTIVE_V

Object Details
Object Name: AS_L_SITES_ACTIVE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_L_SITES_ACTIVE_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


AS_L_SITE_ACTIVE_V replace old view AS_ACCOUNT_CODES_ACTIVE_V. It stores active account address information and relevant information from their foreign keys


[View Source]

Columns
Name Datatype Length Mandatory Comments
SITE_CODE NUMBER (15) Yes Party site identifier
CUSTOMER_ID NUMBER (15) Yes Party identifier
PARTY_ID NUMBER (15) Yes Party identifier
ADDRESS1 VARCHAR2 (240) Yes First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
STATE_PROVINCE VARCHAR2 (121)
State and province
COUNTY VARCHAR2 (60)
County
POSTAL_CODE VARCHAR2 (60)
Postal code
COUNTRY VARCHAR2 (80)
Country
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
CUSTOMER_NAME VARCHAR2 (360) Yes Party name
CUSTOMER_NUMBER VARCHAR2 (30) Yes Party number
ADDRESS_ID NUMBER (15) Yes Party site identifier
PARTY_SITE_ID NUMBER (15) Yes Party site identifier
Query Text

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


SELECT SITE_CODE
,      CUSTOMER_ID
,      PARTY_ID
,      ADDRESS1
,      ADDRESS2
,      CITY
,      STATE
,      PROVINCE
,      STATE_PROVINCE
,      COUNTY
,      POSTAL_CODE
,      COUNTRY
,      ADDRESS3
,      ADDRESS4
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ADDRESS_ID
,      PARTY_SITE_ID
FROM APPS.AS_L_SITES_ACTIVE_V;

Dependencies

[top of page]

APPS.AS_L_SITES_ACTIVE_V references the following:

SchemaAPPS
ViewAS_PARTY_ADDRESSES_V
ViewAS_PARTY_CUSTOMERS_V
SynonymFND_TERRITORIES_TL

APPS.AS_L_SITES_ACTIVE_V is not referenced by any database object