[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
OSM.AS_SALES_CREDITS_DENORM does not reference any database object
OSM.AS_SALES_CREDITS_DENORM is referenced by following:
|
|
|