Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ASF Tables and Views

TABLE - APPS.ASF_LEADS_BIN_MV
TABLE - APPS.ASF_LEADS_CHN_MAIN_MV
TABLE - APPS.ASF_LEADS_CHN_MV
TABLE - APPS.ASF_LEADS_CHN_SUM_MV
TABLE - APPS.ASF_LEADS_CMP_MAIN_MV
TABLE - APPS.ASF_LEADS_CMP_MV
TABLE - APPS.ASF_LEADS_GRP_MV
TABLE - APPS.ASF_LEADS_PRD_MAIN_MV
TABLE - APPS.ASF_LEADS_PRD_MV
TABLE - APPS.ASF_LEADS_PRD_SUM_MV
TABLE - APPS.ASF_LEADS_TOP_MV
TABLE - APPS.ASF_OPP_CHN_FRCST_MV
TABLE - APPS.ASF_OPP_CHN_MV
TABLE - APPS.ASF_OPP_CMP_FRCST_MV
TABLE - APPS.ASF_OPP_CMP_MV
TABLE - APPS.ASF_OPP_PRD_MV
TABLE - APPS.ASF_OPP_TOP_FRCST_MV
TABLE - APPS.ASF_OPP_TOP_MV
TABLE - ASF.ASF_RECORD_VIEW_HISTORY
TABLE - APPS.ASF_SC_BIN_FRCST_MV
TABLE - ASF.ASF_USER_PREFERENCE
TABLE - APPS.ASF_VAR_MV
TABLE - APPS.ASF_WIN_LOSS_COMPTATOR_MV
TABLE - APPS.ASF_WIN_LOSS_MV
TABLE - APPS.ASF_WIN_LOSS_PRODCAT_MV
TABLE - APPS.ASF_WIN_LOSS_TOP5_MV
TABLE - APPS.ASF_WIN_WON_TOP5_MV
VIEW - APPS.ASF_ACCOUNT_SITES_LOV_V
VIEW - APPS.ASF_CNT_PERSON_LOV_V
VIEW - APPS.ASF_COMPETITORS_LOV_V
VIEW - APPS.ASF_EMPLOYEE_LOV_V
VIEW - APPS.ASF_FRCST_SUM_REPRT_V
VIEW - APPS.ASF_HZ_PERSON_LOV_V
VIEW - APPS.ASF_ORGANIZATIONS_QF_V
VIEW - APPS.ASF_ORGANIZATION_RELAT_LOV_V
VIEW - APPS.ASF_PERSONS_QF_V
VIEW - APPS.ASF_PERSON_LOV_V
VIEW - APPS.ASF_PERSON_RELAT_LOV_V

Table: ASF_LEADS_BIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
CNT NUMBER

AMT NUMBER

CONVERSION_STATUS_FLAG NUMBER

[top of page]

APPS.ASF_LEADS_BIN_MV does not reference any database object

APPS.ASF_LEADS_BIN_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_CHN_MAIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CHANNELS NUMBER

BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
CHANNEL_CODE VARCHAR2 (30)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_CHN_MAIN_MV does not reference any database object

APPS.ASF_LEADS_CHN_MAIN_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_CHN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SALES_LEAD_ID NUMBER
Y
BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
CHANNEL_CODE VARCHAR2 (30)
CUSTOMER_ID NUMBER
Y
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

DESCRIPTION VARCHAR2 (2000)

[top of page]

APPS.ASF_LEADS_CHN_MV does not reference any database object

APPS.ASF_LEADS_CHN_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_CHN_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEAD_ID NUMBER
Y
DESCRIPTION VARCHAR2 (2000)
BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
CHANNEL_CODE VARCHAR2 (30)
SOURCE_PROMOTION_ID NUMBER

CUSTOMER_ID NUMBER
Y
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_CHN_SUM_MV does not reference any database object

APPS.ASF_LEADS_CHN_SUM_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_CMP_MAIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CAMPAIGNS NUMBER

BUDGETAMOUNT NUMBER

SOURCE_PROMOTION_ID NUMBER

CURRENCY_CODE CHAR (3)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_CMP_MAIN_MV does not reference any database object

APPS.ASF_LEADS_CMP_MAIN_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_CMP_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SALES_LEAD_ID NUMBER
Y
BUDGETAMOUNT NUMBER

SOURCE_PROMOTION_ID NUMBER

CURRENCY_CODE CHAR (3)
CUSTOMER_ID NUMBER
Y
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

DESCRIPTION VARCHAR2 (2000)

[top of page]

APPS.ASF_LEADS_CMP_MV does not reference any database object

APPS.ASF_LEADS_CMP_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_GRP_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
GROUPS NUMBER

SALES_LEAD_ID NUMBER
Y
BUDGETAMOUNT NUMBER

GROUP_ID NUMBER
Y
CURRENCY_CODE CHAR (3)
PARENT_GROUP_ID NUMBER
Y
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Y
PARENT_RESOURCE_ID NUMBER

ASSIGN_TO_SALESFORCE_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y

[top of page]

APPS.ASF_LEADS_GRP_MV does not reference any database object

APPS.ASF_LEADS_GRP_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_PRD_MAIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
CATEGORY_ID NUMBER

CATEGORY_SET_ID NUMBER

PRODUCTS NUMBER

PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_PRD_MAIN_MV does not reference any database object

APPS.ASF_LEADS_PRD_MAIN_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_PRD_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SALES_LEAD_ID NUMBER
Y
BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
CATEGORY_ID NUMBER

CATEGORY_SET_ID NUMBER

CUSTOMER_ID NUMBER
Y
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_PRD_MV does not reference any database object

APPS.ASF_LEADS_PRD_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_PRD_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEAD_ID NUMBER
Y
DESCRIPTION VARCHAR2 (2000)
BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
CUSTOMER_ID NUMBER
Y
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_ID NUMBER

CATEGORY_SET_ID NUMBER

PRODUCTS NUMBER

PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_PRD_SUM_MV does not reference any database object

APPS.ASF_LEADS_PRD_SUM_MV is not referenced by any database object

[top of page]

Table: ASF_LEADS_TOP_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEADS NUMBER

BUDGETAMOUNT NUMBER

CUSTOMER_ID NUMBER
Y
CURRENCY_CODE CHAR (3)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_LEADS_TOP_MV does not reference any database object

APPS.ASF_LEADS_TOP_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_CHN_FRCST_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEADS NUMBER

LEAD_ID NUMBER
Y
CHANNEL_CODE VARCHAR2 (30)
BUDGET NUMBER

CURRENCY_CODE VARCHAR2 (15)
CONVERSION_STATUS_FLAG NUMBER

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Y
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)

[top of page]

APPS.ASF_OPP_CHN_FRCST_MV does not reference any database object

APPS.ASF_OPP_CHN_FRCST_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_CHN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CHANNEL_CODE VARCHAR2 (30)
LEADS NUMBER

BUDGET NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
MANAGER_PERSON_ID NUMBER

CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15) Y
TO_CURRENCY_CODE VARCHAR2 (15)
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_OPP_CHN_MV does not reference any database object

APPS.ASF_OPP_CHN_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_CMP_FRCST_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEADS NUMBER

LEAD_ID NUMBER
Y
SOURCE_PROMOTION_ID NUMBER

BUDGET NUMBER

CURRENCY_CODE VARCHAR2 (15)
CONVERSION_STATUS_FLAG NUMBER

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Y
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)

[top of page]

APPS.ASF_OPP_CMP_FRCST_MV does not reference any database object

APPS.ASF_OPP_CMP_FRCST_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_CMP_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SOURCE_PROMOTION_ID NUMBER

LEADS NUMBER

BUDGET NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
MANAGER_PERSON_ID NUMBER

CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15) Y
TO_CURRENCY_CODE VARCHAR2 (15)
PARENT_RESOURCE_ID NUMBER

[top of page]

APPS.ASF_OPP_CMP_MV does not reference any database object

APPS.ASF_OPP_CMP_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_PRD_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

LEADS NUMBER

BUDGET NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
MANAGER_PERSON_ID NUMBER

CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15) Y
TO_CURRENCY_CODE VARCHAR2 (15)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Y
CREDIT_TYPE_ID NUMBER

[top of page]

APPS.ASF_OPP_PRD_MV does not reference any database object

APPS.ASF_OPP_PRD_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_TOP_FRCST_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
LEADS NUMBER

SALES_CREDIT_ID NUMBER
Y
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
PARTY_TYPE VARCHAR2 (30)
LEAD_ID NUMBER
Y
OPP_DESCRIPTION VARCHAR2 (240)
BUDGET NUMBER

CURRENCY_CODE VARCHAR2 (15)
CONVERSION_STATUS_FLAG NUMBER

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Y
WIN_PROBABILITY NUMBER

DECISION_DATE DATE

SALES_STAGE VARCHAR2 (60)
STATUS VARCHAR2 (240)
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Y
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)

[top of page]

APPS.ASF_OPP_TOP_FRCST_MV does not reference any database object

APPS.ASF_OPP_TOP_FRCST_MV is not referenced by any database object

[top of page]

Table: ASF_OPP_TOP_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
PARTY_TYPE VARCHAR2 (30)
LEAD_ID NUMBER
Y
TOTAL_AMOUNT NUMBER

OPP_DESCRIPTION VARCHAR2 (240)
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
MANAGER_PERSON_ID NUMBER

CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15) Y
TO_CURRENCY_CODE VARCHAR2 (15)
WIN_PROBABILITY NUMBER

DECISION_DATE DATE

SALES_STAGE VARCHAR2 (60)
STATUS VARCHAR2 (240)
PARENT_RESOURCE_ID NUMBER

CURRENCY_AMOUNT NUMBER

[top of page]

APPS.ASF_OPP_TOP_MV does not reference any database object

APPS.ASF_OPP_TOP_MV is not referenced by any database object

[top of page]

Table: ASF_RECORD_VIEW_HISTORY

Description: This table is used to keep track of the history of which records a user had seen. It has a compositive primary key (object_code, object_id, created_by). The first two are used to specifiy which record, and the third is used to specify who
Primary Key: ASF_RECORD_VIEW_HISTORY_PK
  1. OBJECT_CODE
  2. OBJECT_ID
  3. LAST_UPDATED_BY
Comments

This table is used to keep track of the history of which records a user had seen. It has a compositive primary key (object_code, object_id, created_by). The first two are used to specifiy which record, and the third is used to specify who the user is.

Indexes
Index Type Tablespace Column
ASF_RECORD_VIEW_HISTORY_U1 UNIQUE APPS_TS_TX_IDX OBJECT_CODE
OBJECT_ID
LAST_UPDATED_BY
Columns
Name Datatype Length Mandatory Comments
OBJECT_CODE VARCHAR2 (30) Y Record type identifier. This object code is OBJECT_CODE in JTF_OBJECTS_B.
OBJECT_ID NUMBER
Y The primary key of an object, like lead_id or party_id.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Used by Sales Online portal.

[top of page]

ASF.ASF_RECORD_VIEW_HISTORY does not reference any database object

ASF.ASF_RECORD_VIEW_HISTORY is referenced by following:

APPS
SYNONYM - ASF_RECORD_VIEW_HISTORY

[top of page]

Table: ASF_SC_BIN_FRCST_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CNT NUMBER

PIPELINE_AMOUNT NUMBER

WON_AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
OPP_DELETED_FLAG VARCHAR2 (1)
FORECAST_DATE DATE

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
FORECAST_CATEGORY_ID NUMBER
Y
PERIOD_NAME VARCHAR2 (15) Y
LEAD_ID NUMBER
Y
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Y

[top of page]

APPS.ASF_SC_BIN_FRCST_MV does not reference any database object

APPS.ASF_SC_BIN_FRCST_MV is not referenced by any database object

[top of page]

Table: ASF_USER_PREFERENCE

Description: This table is used to store data for different purpose for individual users specified by USER_ID column.
Primary Key: ASF_USER_PREFERENCE_PK
  1. PREFERENCE_ID
Primary Key: ASF_USER_PREFERENCE_U1
  1. USER_ID
  2. PREFERENCE_CODE
  3. OWNER_TABLE_NAME
  4. OWNER_TABLE_ID
Comments

This table is used to store data for different purpose for individual users specified by USER_ID column.

Indexes
Index Type Tablespace Column
ASF_USER_PREFERENCE_PK UNIQUE APPS_TS_TX_IDX PREFERENCE_ID
ASF_USER_PREFERENCE_U1 UNIQUE APPS_TS_TX_IDX USER_ID
PREFERENCE_CODE
OWNER_TABLE_NAME
OWNER_TABLE_ID
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER (15) Y Generated from a sequence.
USER_ID NUMBER (15) Y For which user this row is for.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OWNER_TABLE_NAME VARCHAR2 (30) Y The object table name, like "HZ_PARTIES"
OWNER_TABLE_ID NUMBER (15) Y The object id, like "PARTY_ID"
CATEGORY VARCHAR2 (30)
Category of preference.
PREFERENCE_CODE VARCHAR2 (30) Y Type of preference.
PREFERENCE_VALUE VARCHAR2 (80) Y Value of preference.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment

[top of page]

ASF.ASF_USER_PREFERENCE does not reference any database object

ASF.ASF_USER_PREFERENCE is referenced by following:

APPS
SYNONYM - ASF_USER_PREFERENCE

[top of page]

Table: ASF_VAR_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
MANAGER_PERSON_ID NUMBER

PARENT_RESOURCE_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
LEAD_ID NUMBER
Y
SALES_CREDIT_AMOUNT NUMBER

CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
OPP_DESCRIPTION VARCHAR2 (240)
WIN_PROBABILITY NUMBER

PARTY_TYPE VARCHAR2 (30)
OPPORTUNITY_CREATION_DATE DATE

CREDIT_TYPE_ID NUMBER

DECISION_DATE DATE

STATUS VARCHAR2 (240)

[top of page]

APPS.ASF_VAR_MV does not reference any database object

APPS.ASF_VAR_MV is not referenced by any database object

[top of page]

Table: ASF_WIN_LOSS_COMPTATOR_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CLOSE_COMPETITOR VARCHAR2 (255)
WIN NUMBER

LOSS NUMBER

FORECAST_ROLLUP_FLAG VARCHAR2 (1)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

CREDIT_TYPE_ID NUMBER

PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
CURRENCY_CODE VARCHAR2 (3)
CURRENCY_AMOUNT NUMBER

[top of page]

APPS.ASF_WIN_LOSS_COMPTATOR_MV does not reference any database object

APPS.ASF_WIN_LOSS_COMPTATOR_MV is not referenced by any database object

[top of page]

Table: ASF_WIN_LOSS_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

SALESFORCE_ID NUMBER

SALES_GROUP_ID NUMBER

PARENT_GROUP_ID NUMBER
Y
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15)
CREDIT_TYPE_ID NUMBER

FORECAST_ROLLUP_FLAG VARCHAR2 (1)
PRODUCT_CATEGORY_ID NUMBER

WON NUMBER

LOSE NUMBER

[top of page]

APPS.ASF_WIN_LOSS_MV does not reference any database object

APPS.ASF_WIN_LOSS_MV is not referenced by any database object

[top of page]

Table: ASF_WIN_LOSS_PRODCAT_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

WON NUMBER

LOSS NUMBER

FORECAST_ROLLUP_FLAG VARCHAR2 (1)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Y
CREDIT_TYPE_ID NUMBER

PARENT_GROUP_ID NUMBER
Y
CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15) Y
CURRENCY_CODE VARCHAR2 (3)

[top of page]

APPS.ASF_WIN_LOSS_PRODCAT_MV does not reference any database object

APPS.ASF_WIN_LOSS_PRODCAT_MV is not referenced by any database object

[top of page]

Table: ASF_WIN_LOSS_TOP5_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
OPP_DESCRIPTION VARCHAR2 (240)
CLOSE_COMPETITOR VARCHAR2 (255)
LEAD_ID NUMBER
Y
SALES_CREDIT_AMOUNT NUMBER

PARTY_ID NUMBER
Y
PARTY_TYPE VARCHAR2 (30)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

CREDIT_TYPE_ID NUMBER

PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (3)
CUR_SALES_CREDIT_AMOUNT NUMBER

[top of page]

APPS.ASF_WIN_LOSS_TOP5_MV does not reference any database object

APPS.ASF_WIN_LOSS_TOP5_MV is not referenced by any database object

[top of page]

Table: ASF_WIN_WON_TOP5_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
OPP_DESCRIPTION VARCHAR2 (240)
CLOSE_COMPETITOR VARCHAR2 (255)
LEAD_ID NUMBER
Y
TOTAL_AMOUNT NUMBER

PARTY_ID NUMBER
Y
PARTY_TYPE VARCHAR2 (30)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Y
PARENT_GROUP_ID NUMBER
Y
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

CREDIT_TYPE_ID NUMBER

PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (3)
CURRENCY_TOTAL_AMOUNT NUMBER

[top of page]

APPS.ASF_WIN_WON_TOP5_MV does not reference any database object

APPS.ASF_WIN_WON_TOP5_MV is not referenced by any database object

[top of page]

View: ASF_ACCOUNT_SITES_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
CUST_ACCT_SITE_ID NUMBER (15) Y Account site identifier
CUST_ACCOUNT_ID NUMBER (15) Y customer account identifer
PARTY_SITE_ID NUMBER (15) Y party site identifer
PARTY_ID VARCHAR2 (0)
null column
STATUS VARCHAR2 (1) Y 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) Y 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) Y 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

[top of page]

APPS.ASF_ACCOUNT_SITES_LOV_V references the following:

APPS
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES

APPS.ASF_ACCOUNT_SITES_LOV_V is not referenced by any database object

[top of page]

View: ASF_CNT_PERSON_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y
OBJECT_ID NUMBER (15) Y
PARTY_NAME VARCHAR2 (360) Y
RELATIONSHIP VARCHAR2 (80) Y
OBJECT_PARTY_NAME VARCHAR2 (360) Y
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
STATUS VARCHAR2 (1) Y
PERSON_FIRST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
PERSON_LAST_NAME VARCHAR2 (150)
PERSON_TITLE VARCHAR2 (30)
PARTY_RELATIONSHIP_TYPE VARCHAR2 (30) Y
PARTY_RELATIONSHIP_ID NUMBER (15) Y
RELATIONSHIP_PARTY_ID NUMBER (15)

[top of page]

APPS.ASF_CNT_PERSON_LOV_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.ASF_CNT_PERSON_LOV_V is not referenced by any database object

[top of page]

View: ASF_COMPETITORS_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y
PARTY_NAME VARCHAR2 (360) Y
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
STATUS VARCHAR2 (1) Y
LEAD_COMPETITOR_ID VARCHAR2 (0)

[top of page]

APPS.ASF_COMPETITORS_LOV_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.ASF_COMPETITORS_LOV_V is not referenced by any database object

[top of page]

View: ASF_EMPLOYEE_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER
Y
FULL_NAME VARCHAR2 (360)
BUSINESS_GROUP_NAME VARCHAR2 (360)
BUSINESS_GROUP_ID NUMBER

FULL_NAME_ID VARCHAR2 (402)
USER_ID NUMBER

JOB_TITLE VARCHAR2 (240)
PHONE VARCHAR2 (2000)
EMAIL VARCHAR2 (2000)

[top of page]

APPS.ASF_EMPLOYEE_LOV_V references the following:

APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS

APPS.ASF_EMPLOYEE_LOV_V is not referenced by any database object

[top of page]

View: ASF_FRCST_SUM_REPRT_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
LEAD_ID NUMBER
Y
DESCRIPTION VARCHAR2 (240)
SALES_GROUP_NAME VARCHAR2 (60)
SALES_GROUP_ID NUMBER

SALES_REP_NAME VARCHAR2 (360)
SALESFORCE_ID NUMBER
Y
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Y
LEAD_NUMBER VARCHAR2 (30) Y
DECISION_DATE DATE

SALES_STAGE VARCHAR2 (60)
SALES_STAGE_ID NUMBER

STATUS VARCHAR2 (240)
STATUS_CODE VARCHAR2 (30) Y
CHANNEL_CODE VARCHAR2 (30)
WIN_PROBABILITY NUMBER

INTEREST_TYPE VARCHAR2 (80)
INTEREST_TYPE_ID NUMBER

PRIMARY_INTEREST_CODE VARCHAR2 (100)
PRIMARY_INTEREST_CODE_ID NUMBER

SECONDARY_INTEREST_CODE VARCHAR2 (100)
SECONDARY_INTEREST_CODE_ID NUMBER

LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CUSTOMER_CATEGORY VARCHAR2 (80)
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
SALES_CREDIT_ID NUMBER
Y
ADDRESS_ID NUMBER

OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
OPP_DELETED_FLAG VARCHAR2 (1)
PARTY_TYPE VARCHAR2 (30)
CONVERSION_TYPE VARCHAR2 (10) Y
TO_CURRENCY_CODE VARCHAR2 (15) Y
CONVERSION_PERIOD_SET_NAME VARCHAR2 (15) Y
CONVERSION_PERIOD_NAME VARCHAR2 (15)
CONVERSION_PERIOD_TYPE VARCHAR2 (15) Y
CONVERSION_DATE DATE

FROM_CURRENCY_CODE VARCHAR2 (15) Y
TOTAL_AMOUNT NUMBER

SALES_CREDIT_AMOUNT NUMBER

WON_AMOUNT NUMBER

WEIGHTED_AMOUNT NUMBER

CONVERSION_STATUS_FLAG NUMBER

CREDIT_TYPE_ID NUMBER

WORKSHEET_ID NUMBER

FORECAST_AMOUNT NUMBER

WORST_FORECAST_AMOUNT NUMBER

BEST_FORECAST_AMOUNT NUMBER

[top of page]

APPS.ASF_FRCST_SUM_REPRT_V references the following:

APPS
SYNONYM - AS_MC_SALES_CREDITS_DEN
SYNONYM - AS_OPP_WORKSHEET_LINES
SYNONYM - AS_SALES_CREDITS_DENORM

APPS.ASF_FRCST_SUM_REPRT_V is not referenced by any database object

[top of page]

View: ASF_HZ_PERSON_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y
PARTY_NAME VARCHAR2 (360) Y
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
STATUS VARCHAR2 (1) Y
PERSON_LAST_NAME VARCHAR2 (150)
PERSON_FIRST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
PERSON_TITLE VARCHAR2 (30)
PARTY_RELATIONSHIP_TYPE VARCHAR2 (0)
PARTY_RELATIONSHIP_ID VARCHAR2 (0)
RELATIONSHIP_PARTY_ID VARCHAR2 (0)

[top of page]

APPS.ASF_HZ_PERSON_LOV_V references the following:

APPS
SYNONYM - HZ_PARTIES

APPS.ASF_HZ_PERSON_LOV_V is not referenced by any database object

[top of page]

View: ASF_ORGANIZATIONS_QF_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15) Y Organization identifier
PARTY_ID NUMBER (15) Y Party ID for Organization
ORG_NAME VARCHAR2 (360) Y Organization Name
ORG_NUMBER VARCHAR2 (30) Y Organization Number
TAX_REFERENCE VARCHAR2 (50)
Tax ID for Organization
STATUS_CODE VARCHAR2 (1) Y 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
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CERTIFICATION_LEVEL VARCHAR2 (30)

[top of page]

APPS.ASF_ORGANIZATIONS_QF_V references the following:

APPS
SYNONYM - HZ_PARTIES

APPS.ASF_ORGANIZATIONS_QF_V is not referenced by any database object

[top of page]

View: ASF_ORGANIZATION_RELAT_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360) Y party name
NAME VARCHAR2 (360) Y party name
PARTY_ID NUMBER (15) Y party identify
PARTY_TYPE VARCHAR2 (30) Y party type
STATUS VARCHAR2 (1) Y party status
REL_PARTY_ID NUMBER (15)
relationship party identifer
SUBJECT_ID NUMBER (15) Y subject identify
OBJECT_ID NUMBER (15) Y object identify
RELATIONSHIP_TYPE VARCHAR2 (80) Y relationship type

[top of page]

APPS.ASF_ORGANIZATION_RELAT_LOV_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.ASF_ORGANIZATION_RELAT_LOV_V is not referenced by any database object

[top of page]

View: ASF_PERSONS_QF_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Y Party identifier of the person
PARTY_ID NUMBER (15) Y Party identifier of the person
SECURITY_ID NUMBER (15) Y Party identifier of the person
PERSON_NAME VARCHAR2 (360) Y Full name
LAST_NAME VARCHAR2 (150)
Last name
FIRST_NAME VARCHAR2 (150)
First name
MIDDLE_NAME VARCHAR2 (60)
Middle name
PREFERRED_NAME VARCHAR2 (240)
Preferred name
STATUS_CODE VARCHAR2 (1) Y Status of the person
EMAIL_ADDRESS VARCHAR2 (2000)
Email address
CONCATENATED_ADDRESS VARCHAR2 (1211)
Concatenated address of the person
ADDRESS VARCHAR2 (963)
Address of the person
ADDRESS1 VARCHAR2 (240)
Address line 1
ADDRESS2 VARCHAR2 (240)
Address line 2
ADDRESS3 VARCHAR2 (240)
Address line 3
ADDRESS4 VARCHAR2 (240)
Address line 4
STATE VARCHAR2 (60)
State
CITY VARCHAR2 (60)
City
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
POSTAL_CODE VARCHAR2 (60)
Postal code
COUNTRY VARCHAR2 (60)
Country
LAST_ORDER_DATE DATE

Standard who column
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

[top of page]

APPS.ASF_PERSONS_QF_V references the following:

APPS
SYNONYM - HZ_PARTIES

APPS.ASF_PERSONS_QF_V is not referenced by any database object

[top of page]

View: ASF_PERSON_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y
OBJECT_ID NUMBER (15) Y
PARTY_NAME VARCHAR2 (360) Y
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
STATUS VARCHAR2 (1) Y
PERSON_LAST_NAME VARCHAR2 (150)
PERSON_FIRST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
PERSON_TITLE VARCHAR2 (30)
PARTY_RELATIONSHIP_TYPE VARCHAR2 (30)
RELATIONSHIP VARCHAR2 (80) Y
PARTY_RELATIONSHIP_ID NUMBER (15) Y
RELATIONSHIP_PARTY_ID NUMBER (15)

[top of page]

APPS.ASF_PERSON_LOV_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - HZ_RELATIONSHIP_TYPES

APPS.ASF_PERSON_LOV_V is not referenced by any database object

[top of page]

View: ASF_PERSON_RELAT_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360) Y party name
NAME VARCHAR2 (150)
party last name
PARTY_ID NUMBER (15) Y party identify
PARTY_TYPE VARCHAR2 (30) Y party type
STATUS VARCHAR2 (1) Y relationship status
REL_PARTY_ID NUMBER (15)
relationship party identify
SUBJECT_ID NUMBER (15) Y relationship subject identify
OBJECT_ID NUMBER (15) Y relationship object identify
RELATIONSHIP_TYPE VARCHAR2 (80) Y relationship type

[top of page]

APPS.ASF_PERSON_RELAT_LOV_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.ASF_PERSON_RELAT_LOV_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract