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: CSD.CSD_RETURNS_BI_MTL_TXNS_F

Object Details

Object Name:	CSD_RETURNS_BI_MTL_TXNS_F
Object Type:	TABLE
Owner:	CSD
FND Design Data:	CSD.CSD_RETURNS_BI_MTL_TXNS_F
Subobject Name:
Status:	VALID

Fact table for material transactions used in Business Intelligence

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_RETURNS_BI_MTL_TXNS_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_ID
CSD_RETURNS_BI_MTL_TXNS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_ID INVENTORY_ORG_ID
CSD_RETURNS_BI_MTL_TXNS_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TRANSACTION_DATE
CSD_RETURNS_BI_MTL_TXNS_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CATEGORY_ID CATEGORY_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Material Transaction Id
OPERATING_UNIT_ID	NUMBER		Yes	Operating Unit Id
INVENTORY_ORG_ID	NUMBER		Yes	Inventory Organization Id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id
TRANSACTED_QTY	NUMBER		Yes	Quantity Transacted
PRIMARY_UOM_CODE	VARCHAR2	(3)	Yes	Unit of Measure for Quantity Transacted
TRANSACTION_DATE	DATE		Yes	Transaction Date (truncated)
REASON_ID	NUMBER			Material Transaction Reason
MTL_DISPOSITION_CODE	VARCHAR2	(30)		Material Disposition Lookup Code
TRANSACTED_WEIGHT	NUMBER			Weight Transacted
WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of Measure for Weight Transacted
CATEGORY_ID	NUMBER			Item Category Id
CATEGORY_SET_ID	NUMBER			Item Category Set Id
INV_GEOGRAPHY_TYPE	VARCHAR2	(30)		Inventory Org Geography Type
INV_GEOGRAPHY_ID	NUMBER			Inventory Org Geography Id
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Concurrent program who column
PROGRAM_LOGIN_ID	NUMBER			Concurrent program who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program who column
REQUEST_ID	NUMBER			Concurrent program who column
RECOVERY_VALUE	NUMBER			Recovery Value
PROCESSING_COST	NUMBER			Processing Cost
CURRENCY_CODE	VARCHAR2	(15)		Currency Code

Query Text

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


SELECT TRANSACTION_ID
,      OPERATING_UNIT_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      TRANSACTED_QTY
,      PRIMARY_UOM_CODE
,      TRANSACTION_DATE
,      REASON_ID
,      MTL_DISPOSITION_CODE
,      TRANSACTED_WEIGHT
,      WEIGHT_UOM_CODE
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      INV_GEOGRAPHY_TYPE
,      INV_GEOGRAPHY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      RECOVERY_VALUE
,      PROCESSING_COST
,      CURRENCY_CODE
FROM CSD.CSD_RETURNS_BI_MTL_TXNS_F;

Dependencies

[top of page]

CSD.CSD_RETURNS_BI_MTL_TXNS_F does not reference any database object

CSD.CSD_RETURNS_BI_MTL_TXNS_F is referenced by following:

APPS: CSD_RETURNS_BI_DISP_SUM_MV; CSD_RETURNS_BI_MTL_TXNS_MV
CSD: CSD_RETURNS_BI_MTL_TXNS_F#