DBA Data[Home] [Help] [Dependency Information]

VIEW: EC.ECE_SPSO_ITEM_DET#

Object Details
Object Name: ECE_SPSO_ITEM_DET#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ITEM_DETAIL_SEQUENCE NUMBER
Yes
SCHEDULE_ID NUMBER
Yes
SCHEDULE_ITEM_ID NUMBER
Yes
DETAIL_CATEGORY VARCHAR2 (25)
DETAIL_DESCRIPTOR VARCHAR2 (25)
DETAIL_DESCRIPTOR_EXT VARCHAR2 (30)
STARTING_DATE DATE

ENDING_DATE DATE

FORECAST_QUANTITY NUMBER

RELEASE_QUANTITY NUMBER

TOTAL_QUANTITY NUMBER

DOCUMENT_TYPE VARCHAR2 (25)
DOCUMENT_NUMBER VARCHAR2 (30)
DOCUMENT_RELEASE_NUMBER NUMBER

DOCUMENT_LINE_NUMBER NUMBER

RUN_ID NUMBER

TRANSACTION_RECORD_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

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# references the following:

SchemaEC
TableECE_SPSO_ITEM_DET
EC.ECE_SPSO_ITEM_DET# is referenced by following:

SchemaAPPS
SynonymECE_SPSO_ITEM_DET