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_SUPPLY_CHAIN

Object Details

Object Name:	CSP_SUPPLY_CHAIN
Object Type:	TABLE
Owner:	CSP
FND Design Data:	CSP.CSP_SUPPLY_CHAIN
Subobject Name:
Status:	VALID

CSP_SUPPLY_CHAIN stores information about the Supply chain generated by "Create ASL Recommendations" concurrent program. Each levl in the Supply Chain has a Parent Supply Chain identifier which identifies the source of Supply for that level. INVENTORY_ITEM_ID identifies the Item. ORGANIZATION_ID identifies the Organization. SECONDARY_INVENTORY identifies the Subinventory. PARENT_SUPPLY_CHAIN_ID identifies the parent in the Supply Chain tree.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSP_SUPPLY_CHAIN_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY
CSP_SUPPLY_CHAIN_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLY_LEVEL
CSP_SUPPLY_CHAIN_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SECONDARY_INVENTORY INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUPPLY_CHAIN_ID	VARCHAR2	(240)		Supply Chain unique identifier
INVENTORY_ITEM_ID	NUMBER	(35)	Yes	Item identifier
ORGANIZATION_ID	NUMBER	(35)	Yes	Organization identifier
SECONDARY_INVENTORY	VARCHAR2	(10)	Yes	Subinventory identifier
PARENT_SUPPLY_CHAIN_ID	NUMBER	(35)		Parent identifier in the Supply Chain tree.
SOURCE_TYPE	NUMBER	(35)		Source type
SOURCE_ORGANIZATION_ID	NUMBER	(35)		Source organization identifier
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source subinventory
LEAD_TIME	NUMBER	(35)		Lead time
SUPPLY_LEVEL	NUMBER	(35)		Supply level
CREATED_BY	NUMBER	(35)	Yes	Standard Who column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(35)	Yes	Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(35)		Standard WHO column
SECURITY_GROUP_ID	NUMBER	(35)		Used in hosted environments

Query Text

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


SELECT SUPPLY_CHAIN_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SECONDARY_INVENTORY
,      PARENT_SUPPLY_CHAIN_ID
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      LEAD_TIME
,      SUPPLY_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM CSP.CSP_SUPPLY_CHAIN;

Dependencies

[top of page]

CSP.CSP_SUPPLY_CHAIN does not reference any database object

CSP.CSP_SUPPLY_CHAIN is referenced by following:

CSP: CSP_SUPPLY_CHAIN#