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: CSP.CSP_RETURN_ROUTING_RULES

Object Details

Object Name:	CSP_RETURN_ROUTING_RULES
Object Type:	TABLE
Owner:	CSP
Subobject Name:
Status:	VALID

Specifies how return of parts will be routed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSP_RETURN_ROUTING_RULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER	(38)	Yes	Unique rule identifier
SOURCE_TYPE	VARCHAR2	(3)		Source type
SOURCE_ORG_ID	NUMBER	(38)		Source organization identifier
SOURCE_SUBINV	VARCHAR2	(30)		Source subinventory name
SOURCE_TERR_ID	NUMBER	(38)		Source territory identifier
RETURN_TYPE	VARCHAR2	(10)		Return type
INV_CAT_SET_ID	NUMBER	(38)		Inventory category set identifier
INV_CAT_ID	NUMBER	(38)		Inventory category identifier
INV_ITEM_ID	NUMBER	(38)		Inventory item identifier
DEST_ORG_ID	NUMBER	(38)		Destination organization identifier
DEST_SUBINV	VARCHAR2	(10)		Destination subinventory name
START_ACTIVE_DATE	DATE			Date when rule is activated
END_ACTIVE_DATE	DATE			Date when rule is de-activiated
ENABLED	VARCHAR2	(3)		Flag indicating if rule is enabled or not
CREATED_BY	NUMBER	(38)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(38)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(38)		Standard WHO column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment Column

Query Text

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


SELECT RULE_ID
,      SOURCE_TYPE
,      SOURCE_ORG_ID
,      SOURCE_SUBINV
,      SOURCE_TERR_ID
,      RETURN_TYPE
,      INV_CAT_SET_ID
,      INV_CAT_ID
,      INV_ITEM_ID
,      DEST_ORG_ID
,      DEST_SUBINV
,      START_ACTIVE_DATE
,      END_ACTIVE_DATE
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM CSP.CSP_RETURN_ROUTING_RULES;

Dependencies

[top of page]

CSP.CSP_RETURN_ROUTING_RULES does not reference any database object

CSP.CSP_RETURN_ROUTING_RULES is referenced by following:

CSP: CSP_RETURN_ROUTING_RULES#