[Home] [Help] [Dependency Information]
Object Name: | AS_SALES_CREDITS_DENORM# |
---|---|
Object Type: | VIEW |
Owner: | OSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_CREDIT_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
SALES_GROUP_ID | NUMBER | |||
SALES_GROUP_NAME | VARCHAR2 | (60) | ||
SALESFORCE_ID | NUMBER | Yes | ||
EMPLOYEE_PERSON_ID | NUMBER | (9) | ||
SALES_REP_NAME | VARCHAR2 | (360) | ||
CUSTOMER_ID | NUMBER | Yes | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
CUSTOMER_CATEGORY | VARCHAR2 | (80) | ||
CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
ADDRESS_ID | NUMBER | |||
LEAD_ID | NUMBER | Yes | ||
LEAD_NUMBER | VARCHAR2 | (30) | Yes | |
OPP_DESCRIPTION | VARCHAR2 | (240) | ||
DECISION_DATE | DATE | |||
SALES_STAGE_ID | NUMBER | |||
SALES_STAGE | VARCHAR2 | (60) | ||
WIN_PROBABILITY | NUMBER | |||
STATUS_CODE | VARCHAR2 | (30) | Yes | |
STATUS | VARCHAR2 | (240) | ||
SECURITY_GROUP_ID | NUMBER | |||
CHANNEL_CODE | VARCHAR2 | (30) | ||
LEAD_SOURCE_CODE | VARCHAR2 | (30) | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
LEAD_LINE_ID | NUMBER | Yes | ||
INTEREST_TYPE_ID | NUMBER | |||
PRIMARY_INTEREST_CODE_ID | NUMBER | |||
SECONDARY_INTEREST_CODE_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
TOTAL_AMOUNT | NUMBER | |||
SALES_CREDIT_AMOUNT | NUMBER | |||
WON_AMOUNT | NUMBER | |||
WEIGHTED_AMOUNT | NUMBER | |||
C1_CURRENCY_CODE | VARCHAR2 | (15) | ||
C1_TOTAL_AMOUNT | NUMBER | |||
C1_SALES_CREDIT_AMOUNT | NUMBER | |||
C1_WON_AMOUNT | NUMBER | |||
C1_WEIGHTED_AMOUNT | NUMBER | |||
LAST_NAME | VARCHAR2 | (360) | ||
FIRST_NAME | VARCHAR2 | (360) | ||
ORG_ID | NUMBER | |||
INTEREST_TYPE | VARCHAR2 | (80) | ||
PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | ||
SECONDARY_INTEREST_CODE | VARCHAR2 | (100) | ||
OPPORTUNITY_LAST_UPDATE_DATE | DATE | Yes | ||
OPPORTUNITY_LAST_UPDATED_BY | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
CONVERSION_STATUS_FLAG | NUMBER | |||
CREDIT_TYPE_ID | NUMBER | |||
QUANTITY | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
UOM_DESCRIPTION | VARCHAR2 | (25) | ||
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | ||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | ||
ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
PARTNER_CUSTOMER_ID | NUMBER | |||
PARTNER_ADDRESS_ID | NUMBER | |||
PARTNER_CUSTOMER_NAME | VARCHAR2 | (360) | ||
PARENT_PROJECT | VARCHAR2 | (80) | ||
SEQUENCE | NUMBER | |||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | ||
OPP_DELETED_FLAG | VARCHAR2 | (1) | ||
PARTY_TYPE | VARCHAR2 | (30) | ||
REVENUE_FLAG | VARCHAR2 | (1) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
OPPORTUNITY_LAST_UPDATED_NAME | VARCHAR2 | (360) | ||
OPPORTUNITY_CREATED_BY | NUMBER | |||
OPPORTUNITY_CREATION_DATE | DATE | |||
OPPORTUNITY_CREATED_NAME | VARCHAR2 | (360) | ||
CLOSE_REASON | VARCHAR2 | (30) | ||
CLOSE_REASON_MEANING | VARCHAR2 | (80) | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
SOURCE_PROMOTION_ID | NUMBER | |||
SALES_METHODOLOGY_ID | NUMBER | |||
FORECAST_DATE | DATE | |||
ROLLING_FORECAST_FLAG | VARCHAR2 | (1) | ||
CLOSE_COMPETITOR_ID | NUMBER | |||
COMPETITOR_NAME | VARCHAR2 | (360) | ||
OWNER_SALESFORCE_ID | NUMBER | |||
OWNER_SALES_GROUP_ID | NUMBER | |||
OWNER_PERSON_NAME | VARCHAR2 | (360) | ||
OWNER_LAST_NAME | VARCHAR2 | (360) | ||
OWNER_FIRST_NAME | VARCHAR2 | (360) | ||
OWNER_GROUP_NAME | VARCHAR2 | (60) | ||
PRODUCT_CATEGORY_ID | NUMBER | |||
PRODUCT_CAT_SET_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
OPP_WORST_FORECAST_AMOUNT | NUMBER | |||
OPP_FORECAST_AMOUNT | NUMBER | |||
OPP_BEST_FORECAST_AMOUNT | NUMBER |
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#;
|
|
|