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_RCV_TXNS_F

Object Details

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

Fact table for receiving 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_RCV_TXNS_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TRANSACTION_DATE
CSD_RETURNS_BI_RCV_TXNS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_ID
CSD_RETURNS_BI_RCV_TXNS_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVENTORY_ORG_ID OPERATING_UNIT_ID
CSD_RETURNS_BI_RCV_TXNS_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CATEGORY_ID CATEGORY_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Receiving Transaction Id
ORDER_HEADER_ID	NUMBER		Yes	Order Header Id
ORDER_LINE_ID	NUMBER		Yes	Order Line 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
RECEIVED_QUANTITY	NUMBER		Yes	Quantity Received
PRIMARY_UOM_CODE	VARCHAR2	(3)	Yes	Primary Unit of Measure
TRANSACTION_DATE	DATE		Yes	Transaction Date (truncated)
RETURN_STREAM_CODE	VARCHAR2	(30)		Return Strean Lookup Code
RECEIVED_WEIGHT	NUMBER			Total Received Weight for Transaction
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight Unit of Measure
RECEIVED_VALUE	NUMBER			Total Received Value for Transaction
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CATEGORY_ID	NUMBER			Item Category Id
CATEGORY_SET_ID	NUMBER			Item Category Set Id
SHIP_GEOGRAPHY_TYPE	VARCHAR2	(30)		Ship Location Geography Type
SHIP_GEOGRAPHY_ID	NUMBER			Ship Location 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_UPDATE_LOGIN	NUMBER			Standard who column
LAST_UPDATED_BY	NUMBER		Yes	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
CUSTOMER_TYPE	VARCHAR2	(30)		Customer Party Type
POM_OFFSET	VARCHAR2	(1)		Put on Market Offset

Query Text

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


SELECT TRANSACTION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      OPERATING_UNIT_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      RECEIVED_QUANTITY
,      PRIMARY_UOM_CODE
,      TRANSACTION_DATE
,      RETURN_STREAM_CODE
,      RECEIVED_WEIGHT
,      WEIGHT_UOM_CODE
,      RECEIVED_VALUE
,      CURRENCY_CODE
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      SHIP_GEOGRAPHY_TYPE
,      SHIP_GEOGRAPHY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      CUSTOMER_TYPE
,      POM_OFFSET
FROM CSD.CSD_RETURNS_BI_RCV_TXNS_F;

Dependencies

[top of page]

CSD.CSD_RETURNS_BI_RCV_TXNS_F does not reference any database object

CSD.CSD_RETURNS_BI_RCV_TXNS_F is referenced by following:

APPS: CSD_RETURNS_BI_POM_MV; CSD_RETURNS_BI_RCV_TXNS_MV
CSD: CSD_RETURNS_BI_RCV_TXNS_F#