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_REQUIREMENT_HEADERS

Object Details

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

Stores information regarding parts requirements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSP_REQUIREMENT_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUIREMENT_HEADER_ID
CSP_REQUIREMENT_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_LOCATION_ID
CSP_REQUIREMENT_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMEZONE_ID
CSP_REQUIREMENT_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ASSIGNMENT_ID
CSP_REQUIREMENT_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_TYPE RESOURCE_ID
CSP_REQUIREMENT_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPPING_METHOD_CODE
CSP_REQUIREMENT_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DESTINATION_ORGANIZATION_ID
CSP_REQUIREMENT_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_TYPE_ID
CSP_REQUIREMENT_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUIREMENT_HEADER_ID	NUMBER	(35)	Yes	Parts order header identifier
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
OPEN_REQUIREMENT	VARCHAR2	(240)		Flag indicating if requirement is open or closed
ADDRESS_TYPE	VARCHAR2	(30)		Address Type. Values are R - Resource Address, C - Customer Address, S - Special Address
SHIP_TO_LOCATION_ID	NUMBER	(35)		Ship to Location Identifier
TIMEZONE_ID	NUMBER	(35)		Timezone Identifier
TASK_ID	NUMBER	(35)		Task identifier
TASK_ASSIGNMENT_ID	NUMBER	(35)		Task Assignment Identifier
RESOURCE_TYPE	VARCHAR2	(240)		Resource Type
RESOURCE_ID	NUMBER	(35)		Resource Identifier
SHIPPING_METHOD_CODE	VARCHAR2	(30)		Shipping Method for the order
NEED_BY_DATE	DATE			Need by date for the parts
DESTINATION_ORGANIZATION_ID	NUMBER	(35)		Destination organization Identifier
DESTINATION_SUBINVENTORY	VARCHAR2	(30)		Destination subinventory
ORDER_TYPE_ID	NUMBER	(35)		Order Type Identifier
PARTS_DEFINED	VARCHAR2	(30)		Flag to specify if required parts are already defined for this requirement or not
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
SECURITY_GROUP_ID	NUMBER			Security group Identifier

Query Text

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


SELECT REQUIREMENT_HEADER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OPEN_REQUIREMENT
,      ADDRESS_TYPE
,      SHIP_TO_LOCATION_ID
,      TIMEZONE_ID
,      TASK_ID
,      TASK_ASSIGNMENT_ID
,      RESOURCE_TYPE
,      RESOURCE_ID
,      SHIPPING_METHOD_CODE
,      NEED_BY_DATE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      ORDER_TYPE_ID
,      PARTS_DEFINED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM CSP.CSP_REQUIREMENT_HEADERS;

Dependencies

[top of page]

CSP.CSP_REQUIREMENT_HEADERS does not reference any database object

CSP.CSP_REQUIREMENT_HEADERS is referenced by following:

APPS: CSP_REQUIREMENT_HEADERS