VIEW: EC.ECE_SPSO_ITEM_DET#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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