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

VIEW: APPS.ASF_ACCOUNT_SITES_LOV_V

Object Details
Object Name: ASF_ACCOUNT_SITES_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASF.ASF_ACCOUNT_SITES_LOV_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 Account site identifier
CUST_ACCOUNT_ID NUMBER (15) Yes customer account identifer
PARTY_SITE_ID NUMBER (15) Yes party site identifer
PARTY_ID VARCHAR2 (0)
null column
STATUS VARCHAR2 (1) Yes account site status
PRIMARY_FLAG VARCHAR2 (1)
site use primary flag
SITE_USE_CODE VARCHAR2 (30)
customer site use site use code
ADDRESS1 VARCHAR2 (240) Yes First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Forth line for address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
COUNTRY VARCHAR2 (60) Yes Country
COUNTY VARCHAR2 (60)
County
POSTAL_CODE VARCHAR2 (60)
Postal Code
PROVINCE VARCHAR2 (60)
Province
VALID_ADDR_FLAG CHAR (1)
This flag indicate if address segments are valid
Query Text

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


SELECT CUST_ACCT_SITE_ID
,      CUST_ACCOUNT_ID
,      PARTY_SITE_ID
,      PARTY_ID
,      STATUS
,      PRIMARY_FLAG
,      SITE_USE_CODE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      COUNTRY
,      COUNTY
,      POSTAL_CODE
,      PROVINCE
,      VALID_ADDR_FLAG
FROM APPS.ASF_ACCOUNT_SITES_LOV_V;

Dependencies

[top of page]

APPS.ASF_ACCOUNT_SITES_LOV_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES

APPS.ASF_ACCOUNT_SITES_LOV_V is not referenced by any database object