eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ASF_ORGANIZATIONS_QF_V

Object Details

Object Name:	ASF_ORGANIZATIONS_QF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ASF.ASF_ORGANIZATIONS_QF_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
ORG_ID	NUMBER	(15)	Yes	Organization identifier
PARTY_ID	NUMBER	(15)	Yes	Party ID for Organization
ORG_NAME	VARCHAR2	(360)	Yes	Organization Name
ORG_NUMBER	VARCHAR2	(30)	Yes	Organization Number
TAX_REFERENCE	VARCHAR2	(50)		Tax ID for Organization
STATUS_CODE	VARCHAR2	(1)	Yes	Status for Organization
SIC_CODE	VARCHAR2	(30)		SI Code for Organization
CATEGORY_CODE	VARCHAR2	(30)		Category Code for Organization
URL	VARCHAR2	(2000)		Web site address for Organization
ADDRESS_BOOK	VARCHAR2	(1211)		Full Address for Organization
ADDRESS	VARCHAR2	(963)		Address for Organization
ADDRESS1	VARCHAR2	(240)		Address1 for Organization
ADDRESS2	VARCHAR2	(240)		Address2 for Organization
ADDRESS3	VARCHAR2	(240)		Address3 for Organization
ADDRESS4	VARCHAR2	(240)		Address4 for Organization
STATE	VARCHAR2	(60)		State for Organization Address
CITY	VARCHAR2	(60)		City for Organization Address
PROVINCE	VARCHAR2	(60)		Province for Organization Address
COUNTY	VARCHAR2	(60)		County for Organization Address
POSTAL_CODE	VARCHAR2	(60)		Postal Code for Organization Address
COUNTRY	VARCHAR2	(60)		Country for Organization Address
ALIAS	VARCHAR2	(240)		Alias for Organization
YEAR_ESTABLISHED	NUMBER	(4)		Year Established for Organization
EMAIL	VARCHAR2	(2000)		Email for Organization
FISCAL_YEAREND_MONTH	VARCHAR2	(30)		Fiscal Year End Month for Organization
LAST_ORDER_DATE	DATE			Last Order Date for Organization
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CERTIFICATION_LEVEL	VARCHAR2	(30)

Query Text

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


SELECT ORG_ID
,      PARTY_ID
,      ORG_NAME
,      ORG_NUMBER
,      TAX_REFERENCE
,      STATUS_CODE
,      SIC_CODE
,      CATEGORY_CODE
,      URL
,      ADDRESS_BOOK
,      ADDRESS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      STATE
,      CITY
,      PROVINCE
,      COUNTY
,      POSTAL_CODE
,      COUNTRY
,      ALIAS
,      YEAR_ESTABLISHED
,      EMAIL
,      FISCAL_YEAREND_MONTH
,      LAST_ORDER_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      CERTIFICATION_LEVEL
FROM APPS.ASF_ORGANIZATIONS_QF_V;

Dependencies

[top of page]

APPS.ASF_ORGANIZATIONS_QF_V references the following:

APPS: HZ_PARTIES

APPS.ASF_ORGANIZATIONS_QF_V is not referenced by any database object