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: CSL.CSL_CSP_REQUIREMENT_HDR_INQ

Object Details

Object Name:	CSL_CSP_REQUIREMENT_HDR_INQ
Object Type:	TABLE
Owner:	CSL
Subobject Name:
Status:	VALID

Inqueue table for CSP_REQUIREMENT_HEADERS containing data uploaded by mobile clients

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSL_CSP_REQUIREMENT_HDR_INQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANID$$ CLID$$CS SEQNO$$

Columns

Name	Datatype	Length	Comments
CLID$$CS	VARCHAR2	(240)	Mobile username refers to FND_USER
REQUIREMENT_HEADER_ID	NUMBER	(35)	Parts order header identifier
CREATION_DATE	DATE		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
DMLTYPE$$	VARCHAR2	(1)	DML code
SEQNO$$	NUMBER	(10)	Oracle Lite sequence number
TRANID$$	NUMBER	(10)	Transaction id
VERSION$$	NUMBER	(10)	Record version

Query Text

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


SELECT CLID$$CS
,      REQUIREMENT_HEADER_ID
,      CREATION_DATE
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSL.CSL_CSP_REQUIREMENT_HDR_INQ;

Dependencies

[top of page]

CSL.CSL_CSP_REQUIREMENT_HDR_INQ does not reference any database object

CSL.CSL_CSP_REQUIREMENT_HDR_INQ is referenced by following:

APPS: CSL_CSP_REQUIREMENT_HDR_INQ