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: CZ.CZ_ATP_REQUESTS

Object Details

Object Name:	CZ_ATP_REQUESTS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_ATP_REQUESTS
Subobject Name:
Status:	VALID

This table is used to pass item/config information to a PL/SQL callback procedure used for calculating ATP (availability-to-promise) for those items.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: CZ_ATP_REQUESTS_PK

ATP_REQUEST_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_ATP_REQUESTS_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ATP_REQUEST_ID
CZ_ATP_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CONFIGURATOR_SESSION_KEY SEQ_NO
CZ_ATP_REQUESTS_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CONFIGURATOR_SESSION_KEY CONFIG_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIGURATOR_SESSION_KEY	VARCHAR2	(50)	Yes	Configurator Session Key is used to group all of the ATP request records associated with a single session in the Configurator.
SEQ_NO	NUMBER	(9)	Yes	Sequential number distinguishing records in the same configurator session
PS_NODE_ID	NUMBER	(15)		Holds the ps_node_id of the structure node for which ATP information is requested.
ITEM_KEY	VARCHAR2	(2000)	Yes	String carrying an identifier for an item for which ATP is to be determined.
ITEM_KEY_TYPE	NUMBER	(9)	Yes	Code indicating the format for the ITEM_KEY field. 1 - 'orig_sys_ref' format CC:EX:ORG:ITEM, CC is component code, EX is explosion type, ORG is organization ID, ITEM is inventory item ID; 2 - ps_node_id
QUANTITY	NUMBER			Quantity requested for this item
UOM_CODE	VARCHAR2	(3)		Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
INV_ORG_ID	NUMBER	(9)		Inventory-organization ID from which item would be available.
SHIP_TO_DATE	DATE			Date the item is available in the requested quantity.
MSG_DATA	VARCHAR2	(2000)		Information returned from the ATP engine to the Configurator. GENERALLY UNUSED.
ATP_REQUEST_ID	NUMBER		Yes	Primary key ID. Distinguishes each atp request line with a unique number.
CONFIG_ITEM_ID	NUMBER		Yes	Directly attach ATP-query record to the associated config item
PARENT_CONFIG_ITEM_ID	NUMBER	(15)		Directly attach ATP-query record to the parent of the associated config item
ATO_CONFIG_ITEM_ID	NUMBER			Input value used to determine ato_model_line_id for ATP call.
COMPONENT_SEQUENCE_ID	NUMBER			Input value used as component_sequence_id input to ATP call.
NEED_BY_DATE	DATE			For future use, will store value returned by ATP API.
DAYS_LATE	NUMBER			For future use, will store value returned by ATP API.

Query Text

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


SELECT CONFIGURATOR_SESSION_KEY
,      SEQ_NO
,      PS_NODE_ID
,      ITEM_KEY
,      ITEM_KEY_TYPE
,      QUANTITY
,      UOM_CODE
,      INV_ORG_ID
,      SHIP_TO_DATE
,      MSG_DATA
,      ATP_REQUEST_ID
,      CONFIG_ITEM_ID
,      PARENT_CONFIG_ITEM_ID
,      ATO_CONFIG_ITEM_ID
,      COMPONENT_SEQUENCE_ID
,      NEED_BY_DATE
,      DAYS_LATE
FROM CZ.CZ_ATP_REQUESTS;

Dependencies

[top of page]

CZ.CZ_ATP_REQUESTS does not reference any database object

CZ.CZ_ATP_REQUESTS is referenced by following:

APPS: CZ_ATP_REQUESTS