[Home] [Help] [Dependency Information]

TABLE: EC.ECE_SPSO_ITEM_DET

Object Details

Object Name:	ECE_SPSO_ITEM_DET
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_SPSO_ITEM_DET
Subobject Name:
Status:	VALID

ECE_SPSO_ITEM_DET contains supplier schedule data to support the
outbound Planning Schedule (830/DELFOR) and Shipping Schedule
(862/DELJIT) transactions.

ECE_SPSO_ITEM_DET is based primarily on data stored in
CHV_HORIZONTAL_SCHEDULES in Oracle Supplier Scheduling.

ECE_SPSO_ITEM_DET contains the horizontal, bucketed representation
of a scheduled item associated with each confirmed planning or
shipping schedule identified by the Oracle Supplier Scheduler
Workbench, the Oracle Supplier Scheduling AutoSchedule process, or
selected by the e-Commerce Gateway user.

Each row in ECE_SPSO_ITEM_DET is associated with one row in
ECE_SPSO_ITEMS. There is a one-to-many relationship between
ECE_SPSO_ITEMS and ECE_SPSO_ITEM_DET.

Each row in ECE_SPSO_ITEM_DET represents one of the following types of
data:
{{"bul:1"}}Requirements: Up to 60 occurrences per the user-defined
bucket pattern and planning horizon for the schedule.
{{"bul:1"}}Prior Authorizations: One occurrence if authorizations are
enabled at the approved supplier list for the planning schedule or
shipping schedule.

{{"bul:1"}}Authorizations: One occurrence for each authorization type
if authorizations are enabled at the approved Ssupplier list.
Authorizations cover raw material, labor, labor and material or
finished goods. Resource authorizations are supported for planning
schedules only.
{{"bul:1"}}Last Receipt: One occurrence identifying the quantity,
date, and shipment number of the last receipt for the item.
{{"bul:1"}}Cumulative Receipt: One occurrence identifying the
cumulative receipt quantity for the item if CUM accounting is enabled.
{{"bodytext"}}SCHEDULE_ITEM_DETAIL_SEQUENCE, SCHEDULE_ID, and
SCHEDULE_ITEM_ID are the primary keys for this table.

RUN_ID uniquely identifies the session that created the row in
ECE_SPSO_ITEM_DET since this table is shared by two
transactions.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.

Each row in ECE_SPSO_ITEM_DET is purged after the data is written to
the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_SPSO_ITEM_DET table to its corresponding extension table
ECE_SPSO_ITEM_DET_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_SPSO_ITEM_DET_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	SCHEDULE_ITEM_DETAIL_SEQUENCE SCHEDULE_ID SCHEDULE_ITEM_ID RUN_ID
ECE_SPSO_ITEM_DET_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SCHEDULE_ID SCHEDULE_ITEM_ID RUN_ID

Columns

Query Text

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

SELECT SCHEDULE_ITEM_DETAIL_SEQUENCE
,      SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      DETAIL_CATEGORY
,      DETAIL_DESCRIPTOR
,      DETAIL_DESCRIPTOR_EXT
,      STARTING_DATE
,      ENDING_DATE
,      FORECAST_QUANTITY
,      RELEASE_QUANTITY
,      TOTAL_QUANTITY
,      DOCUMENT_TYPE
,      DOCUMENT_NUMBER
,      DOCUMENT_RELEASE_NUMBER
,      DOCUMENT_LINE_NUMBER
,      RUN_ID
,      TRANSACTION_RECORD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_SPSO_ITEM_DET;

Dependencies

[top of page]

EC.ECE_SPSO_ITEM_DET does not reference any database object

EC.ECE_SPSO_ITEM_DET is referenced by following:

APPS

ECE_SPSO_ITEM_DET