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_MC_SALES_CREDITS_DEN

Object Details

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

Multi currency table to store sales credit amounts converted in various reporting currencies based on daily as well as pseudo period rates

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_MC_SALES_CREDITS_DEN_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	MC_SALES_CREDIT_ID
AS_MC_SALES_CREDITS_DEN_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CONVERSION_PERIOD_SET_NAME CONVERSION_PERIOD_NAME
AS_MC_SALES_CREDITS_DEN_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CONVERSION_DATE
AS_MC_SALES_CREDITS_DEN_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SALES_CREDIT_ID TO_CURRENCY_CODE CONVERSION_PERIOD_SET_NAME CONVERSION_PERIOD_NAME
AS_MC_SALES_CREDITS_DEN_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SALES_CREDIT_ID TO_CURRENCY_CODE CONVERSION_DATE
AS_MC_SALES_CREDITS_DEN_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SALES_CREDIT_ID TO_CURRENCY_CODE CONVERSION_PERIOD_SET_NAME TYPE CONVERSION_PERIOD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
MC_SALES_CREDIT_ID	NUMBER		Yes	sequence generated unique key
SALES_CREDIT_ID	NUMBER		Yes	SALES_CREDIT_ID
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		Yes	Standard who column.
CONVERSION_TYPE	VARCHAR2	(10)	Yes	Currency conversion type
TO_CURRENCY_CODE	VARCHAR2	(15)	Yes	Target currency code in currency conversion
CONVERSION_PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Currency conversion period set name
CONVERSION_PERIOD_NAME	VARCHAR2	(15)		Currency conversion period name
CONVERSION_DATE	DATE			The date which rate is used in currency conversion
FROM_CURRENCY_CODE	VARCHAR2	(15)	Yes	The source currency code in the currency conversion
TOTAL_AMOUNT	NUMBER			The converted total amount from AS_SALES_CREDITS_DENORM
SALES_CREDIT_AMOUNT	NUMBER			The converted sales credit amount from AS_SALES_CREDITS_DENORM
WON_AMOUNT	NUMBER			The converted won amount from AS_SALES_CREDITS_DENORM
WEIGHTED_AMOUNT	NUMBER			The converted weighted amount from AS_SALES_CREDITS_DENORM
CONVERSION_PERIOD_TYPE	VARCHAR2	(15)	Yes	The currency conversion period type
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			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
TYPE	VARCHAR2	(10)		conversion rate type either of PSEUDO_RATE or DAILY
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
CONVERSION_RATE_STATUS	NUMBER
CONVERSION_RATE_FOUND	VARCHAR2	(1)	Yes	Flag to indicate the currency conversion status

Query Text

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


SELECT MC_SALES_CREDIT_ID
,      SALES_CREDIT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONVERSION_TYPE
,      TO_CURRENCY_CODE
,      CONVERSION_PERIOD_SET_NAME
,      CONVERSION_PERIOD_NAME
,      CONVERSION_DATE
,      FROM_CURRENCY_CODE
,      TOTAL_AMOUNT
,      SALES_CREDIT_AMOUNT
,      WON_AMOUNT
,      WEIGHTED_AMOUNT
,      CONVERSION_PERIOD_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONVERSION_STATUS_FLAG
,      TYPE
,      SECURITY_GROUP_ID
,      CONVERSION_RATE_STATUS
,      CONVERSION_RATE_FOUND
FROM OSM.AS_MC_SALES_CREDITS_DEN;

Dependencies

[top of page]

OSM.AS_MC_SALES_CREDITS_DEN does not reference any database object

OSM.AS_MC_SALES_CREDITS_DEN is referenced by following:

OSM: AS_MC_SALES_CREDITS_DEN#