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]

TABLE: OSM.AS_SALES_CREDITS_DENORM

Object Details

Object Name:	AS_SALES_CREDITS_DENORM
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_SALES_CREDITS_DENORM
Subobject Name:
Status:	VALID

Denormalized table to store opportunity data denormalized from AS_LEADS_ALL, AS_LEAD_LINES_ALL, AS_SALES_CREDITS, AS_SALES_STAGE_ALL, AS_INTEREST_TYPES_ALL, AS_INTEREST_CODES_ALL, HZ_PARTIES, AS_SALES_GROUPS, PER_ALL_PEOPLR_F

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_SALES_CREDITS_DENORM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SALES_CREDIT_ID
AS_SALES_CREDITS_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_PERSON_ID
AS_SALES_CREDITS_DENORM_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_NUMBER
AS_SALES_CREDITS_DENORM_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALESFORCE_ID DECISION_DATE
AS_SALES_CREDITS_DENORM_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORECAST_DATE STATUS_CODE EMPLOYEE_PERSON_ID SALES_GROUP_ID LEAD_ID C1_SALES_CREDIT_AMOUNT
AS_SALES_CREDITS_DENORM_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALESFORCE_ID FORECAST_DATE
AS_SALES_CREDITS_DENORM_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORECAST_DATE STATUS_CODE SALESFORCE_ID SALES_GROUP_ID LEAD_ID C1_SALES_CREDIT_AMOUNT
AS_SALES_CREDITS_DENORM_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECISION_DATE STATUS_CODE SALESFORCE_ID SALES_GROUP_ID LEAD_ID C1_SALES_CREDIT_AMOUNT
AS_SALES_CREDITS_DENORM_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_TYPE_ID FORECAST_DATE STATUS_CODE SALES_GROUP_ID
AS_SALES_CREDITS_DENORM_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
AS_SALES_CREDITS_DENORM_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID
AS_SALES_CREDITS_DENORM_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_CUSTOMER_ID
AS_SALES_CREDITS_DENORM_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_ADDRESS_ID
AS_SALES_CREDITS_DENORM_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_SALESFORCE_ID OWNER_SALES_GROUP_ID
AS_SALES_CREDITS_DENORM_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
AS_SALES_CREDITS_DENORM_N27	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_GROUP_ID FORECAST_DATE CREDIT_TYPE_ID PRODUCT_CATEGORY_ID FORECAST_ROLLUP_FLAG SALESFORCE_ID
AS_SALES_CREDITS_DENORM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_GROUP_ID STATUS_CODE PRODUCT_CATEGORY_ID PRODUCT_CAT_SET_ID
AS_SALES_CREDITS_DENORM_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_GROUP_ID PRODUCT_CATEGORY_ID PRODUCT_CAT_SET_ID
AS_SALES_CREDITS_DENORM_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_ID STATUS_CODE DECISION_DATE
AS_SALES_CREDITS_DENORM_N6	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("OPP_DESCRIPTION")
AS_SALES_CREDITS_DENORM_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_GROUP_ID DECISION_DATE
AS_SALES_CREDITS_DENORM_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_LINE_ID
AS_SALES_CREDITS_DENORM_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECISION_DATE STATUS_CODE EMPLOYEE_PERSON_ID SALES_GROUP_ID LEAD_ID C1_SALES_CREDIT_AMOUNT

Columns

Name	Datatype	Length	Mandatory	Comments
SALES_CREDIT_ID	NUMBER		Yes	Sales credit identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER			Standard who column.
SALES_GROUP_ID	NUMBER			Sales group identifier
SALES_GROUP_NAME	VARCHAR2	(60)		Name of the sales group
SALESFORCE_ID	NUMBER		Yes	Salesforce identifier
EMPLOYEE_PERSON_ID	NUMBER	(9)		Employee identifier
SALES_REP_NAME	VARCHAR2	(360)		Name of sales representative
CUSTOMER_ID	NUMBER		Yes	Customer identifier
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
CUSTOMER_CATEGORY	VARCHAR2	(80)		User-defined customer category
CUSTOMER_CATEGORY_CODE	VARCHAR2	(30)		Code of customer category
ADDRESS_ID	NUMBER			Address identifier
LEAD_ID	NUMBER		Yes	Lead identifier
LEAD_NUMBER	VARCHAR2	(30)	Yes	Lead number
OPP_DESCRIPTION	VARCHAR2	(240)		A description of the opportunity
DECISION_DATE	DATE			The date the purchase will be made by the prospect
SALES_STAGE_ID	NUMBER			Sales stage identifier
SALES_STAGE	VARCHAR2	(60)		Sales stage name
WIN_PROBABILITY	NUMBER			The percentage or the probability that this opportunity will result in a sale
STATUS_CODE	VARCHAR2	(30)	Yes	Code of the status of this opportunity
STATUS	VARCHAR2	(240)		The status of this opportunity
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
CHANNEL_CODE	VARCHAR2	(30)		Sales channel for this opportunity
LEAD_SOURCE_CODE	VARCHAR2	(30)		Original source of opportunity
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Unique opportunity identifier from foreign system
LEAD_LINE_ID	NUMBER		Yes	Opportunity item identifier
INTEREST_TYPE_ID	NUMBER			Obsolete. The interest type identifier for the opportunity
PRIMARY_INTEREST_CODE_ID	NUMBER			Obsolete. Primary interest code identifier
SECONDARY_INTEREST_CODE_ID	NUMBER			Obsolete. Secondary interest code identifier
CURRENCY_CODE	VARCHAR2	(15)		The currency code used for this opportunity
TOTAL_AMOUNT	NUMBER			The amount of the sale likely to result from this lead item
SALES_CREDIT_AMOUNT	NUMBER			Sales credit amount
WON_AMOUNT	NUMBER			sales_credit_amount if status is 'WON'
WEIGHTED_AMOUNT	NUMBER			sales_credit_amount * win_probability/100
C1_CURRENCY_CODE	VARCHAR2	(15)		User's currecny code
C1_TOTAL_AMOUNT	NUMBER			Total amount in USD
C1_SALES_CREDIT_AMOUNT	NUMBER			Sales credit amount in USD
C1_WON_AMOUNT	NUMBER			Won amount in USD
C1_WEIGHTED_AMOUNT	NUMBER			Weighted amount in USD
LAST_NAME	VARCHAR2	(360)		Sales rep's last name
FIRST_NAME	VARCHAR2	(360)		Sales rep's first name
ORG_ID	NUMBER			Operating unit which performed this transaction
INTEREST_TYPE	VARCHAR2	(80)		Obsolete. Interest type
PRIMARY_INTEREST_CODE	VARCHAR2	(100)		Obsolete. Primary Interest Code
SECONDARY_INTEREST_CODE	VARCHAR2	(100)		Obsolete. Secondary Interest Code
OPPORTUNITY_LAST_UPDATE_DATE	DATE		Yes	Last date the opportunity was updated
OPPORTUNITY_LAST_UPDATED_BY	NUMBER		Yes	The user identifier that the opportunity was last updated by
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
CONVERSION_STATUS_FLAG	NUMBER			Flag to indicate the currency conversion status
CREDIT_TYPE_ID	NUMBER			from as_sales_credits
QUANTITY	NUMBER			from as_lead_lines_all
UOM_CODE	VARCHAR2	(3)		from as_lead_lines_all
UOM_DESCRIPTION	VARCHAR2	(25)		description for UOM_CODE
FORECAST_ROLLUP_FLAG	VARCHAR2	(1)		Flag to indicate opportunity with this status will appear in forecast. Valid values are 'Y' and 'N'
WIN_LOSS_INDICATOR	VARCHAR2	(1)		from as_statuses_b
ITEM_ID	NUMBER			from as_lead_lines_all
ORGANIZATION_ID	NUMBER			from as_lead_lines_all
ITEM_DESCRIPTION	VARCHAR2	(240)		description for item_id
PARTNER_CUSTOMER_ID	NUMBER			Customer identifier for a partner
PARTNER_ADDRESS_ID	NUMBER			Address Identifier of a partner
PARTNER_CUSTOMER_NAME	VARCHAR2	(360)		Customer name for a partner
PARENT_PROJECT	VARCHAR2	(80)		Project to which this lead belongs
SEQUENCE	NUMBER			For multi-threading use
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number from per_people_all
OPP_OPEN_STATUS_FLAG	VARCHAR2	(1)		from as_statuses_b
OPP_DELETED_FLAG	VARCHAR2	(1)		soft delete flag from as_leads_all
PARTY_TYPE	VARCHAR2	(30)		party_type from hz_parties table
REVENUE_FLAG	VARCHAR2	(1)		Flag to indicate credit type is revenue or not
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
OPPORTUNITY_LAST_UPDATED_NAME	VARCHAR2	(360)		Opportunity header last updated name
OPPORTUNITY_CREATED_BY	NUMBER			Opportunity header standard who column
OPPORTUNITY_CREATION_DATE	DATE			Opportunity standard who column
OPPORTUNITY_CREATED_NAME	VARCHAR2	(360)		Opportunity header created name
CLOSE_REASON	VARCHAR2	(30)		A reason for closing an opportunity, validated against 'CLOSE_REASON' from fnd_lookup_values
CLOSE_REASON_MEANING	VARCHAR2	(80)		A reason meaning for closing an opportunity
BUSINESS_GROUP_NAME	VARCHAR2	(240)		Operating unit name which performed this transaction
SOURCE_PROMOTION_ID	NUMBER			Promotion identfier that initiated the creation of the lead
SALES_METHODOLOGY_ID	NUMBER			Sales Methodology Identifier of this lead
FORECAST_DATE	DATE			The date that to be used for forecasting
ROLLING_FORECAST_FLAG	VARCHAR2	(1)		Flag to indicate that the forecast date is defaulted from close date in as_leads_all
CLOSE_COMPETITOR_ID	NUMBER			Customer identifier that is marked as a competitor
COMPETITOR_NAME	VARCHAR2	(360)		Competitor name
OWNER_SALESFORCE_ID	NUMBER			Owner salesforce identifier
OWNER_SALES_GROUP_ID	NUMBER			Owner sales group identifier
OWNER_PERSON_NAME	VARCHAR2	(360)		Name of sales representative
OWNER_LAST_NAME	VARCHAR2	(360)		Sales rep's last name
OWNER_FIRST_NAME	VARCHAR2	(360)		Sales rep's first name
OWNER_GROUP_NAME	VARCHAR2	(60)		Name of the sales group
PRODUCT_CATEGORY_ID	NUMBER			Maps to the new product category
PRODUCT_CAT_SET_ID	NUMBER			Stores the category set id of the catalog
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
OPP_WORST_FORECAST_AMOUNT	NUMBER			Worst Forecast Amount for Opportunity
OPP_FORECAST_AMOUNT	NUMBER			Forecast Amount for Opportunity
OPP_BEST_FORECAST_AMOUNT	NUMBER			Best Forecast Amount for Opportunity

Query Text

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


SELECT SALES_CREDIT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SALES_GROUP_ID
,      SALES_GROUP_NAME
,      SALESFORCE_ID
,      EMPLOYEE_PERSON_ID
,      SALES_REP_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_CATEGORY
,      CUSTOMER_CATEGORY_CODE
,      ADDRESS_ID
,      LEAD_ID
,      LEAD_NUMBER
,      OPP_DESCRIPTION
,      DECISION_DATE
,      SALES_STAGE_ID
,      SALES_STAGE
,      WIN_PROBABILITY
,      STATUS_CODE
,      STATUS
,      SECURITY_GROUP_ID
,      CHANNEL_CODE
,      LEAD_SOURCE_CODE
,      ORIG_SYSTEM_REFERENCE
,      LEAD_LINE_ID
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      CURRENCY_CODE
,      TOTAL_AMOUNT
,      SALES_CREDIT_AMOUNT
,      WON_AMOUNT
,      WEIGHTED_AMOUNT
,      C1_CURRENCY_CODE
,      C1_TOTAL_AMOUNT
,      C1_SALES_CREDIT_AMOUNT
,      C1_WON_AMOUNT
,      C1_WEIGHTED_AMOUNT
,      LAST_NAME
,      FIRST_NAME
,      ORG_ID
,      INTEREST_TYPE
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE
,      OPPORTUNITY_LAST_UPDATE_DATE
,      OPPORTUNITY_LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CONVERSION_STATUS_FLAG
,      CREDIT_TYPE_ID
,      QUANTITY
,      UOM_CODE
,      UOM_DESCRIPTION
,      FORECAST_ROLLUP_FLAG
,      WIN_LOSS_INDICATOR
,      ITEM_ID
,      ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      PARTNER_CUSTOMER_ID
,      PARTNER_ADDRESS_ID
,      PARTNER_CUSTOMER_NAME
,      PARENT_PROJECT
,      SEQUENCE
,      EMPLOYEE_NUMBER
,      OPP_OPEN_STATUS_FLAG
,      OPP_DELETED_FLAG
,      PARTY_TYPE
,      REVENUE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OPPORTUNITY_LAST_UPDATED_NAME
,      OPPORTUNITY_CREATED_BY
,      OPPORTUNITY_CREATION_DATE
,      OPPORTUNITY_CREATED_NAME
,      CLOSE_REASON
,      CLOSE_REASON_MEANING
,      BUSINESS_GROUP_NAME
,      SOURCE_PROMOTION_ID
,      SALES_METHODOLOGY_ID
,      FORECAST_DATE
,      ROLLING_FORECAST_FLAG
,      CLOSE_COMPETITOR_ID
,      COMPETITOR_NAME
,      OWNER_SALESFORCE_ID
,      OWNER_SALES_GROUP_ID
,      OWNER_PERSON_NAME
,      OWNER_LAST_NAME
,      OWNER_FIRST_NAME
,      OWNER_GROUP_NAME
,      PRODUCT_CATEGORY_ID
,      PRODUCT_CAT_SET_ID
,      OBJECT_VERSION_NUMBER
,      OPP_WORST_FORECAST_AMOUNT
,      OPP_FORECAST_AMOUNT
,      OPP_BEST_FORECAST_AMOUNT
FROM OSM.AS_SALES_CREDITS_DENORM;

Dependencies

[top of page]

OSM.AS_SALES_CREDITS_DENORM does not reference any database object

OSM.AS_SALES_CREDITS_DENORM is referenced by following:

OSM: AS_SALES_CREDITS_DENORM#