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]

VIEW: EC.ECE_SPSO_ITEMS#

Object Details

Object Name:	ECE_SPSO_ITEMS#
Object Type:	VIEW
Owner:	EC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SCHEDULE_ID	NUMBER		Yes
SCHEDULE_ITEM_ID	NUMBER		Yes
ITEM_NUMBER	VARCHAR2	(100)
PRODUCT_DESCRIPTION	VARCHAR2	(240)
STARTING_AUTH_QUANTITY	NUMBER
STARTING_CUM_QUANTITY	NUMBER
LAST_RECEIPT_SHIPMENT_CODE	VARCHAR2	(30)
LAST_RECEIPT_DATE	DATE
LAST_RECEIPT_QUANTITY	NUMBER
LAST_RECEIPT_CUM_QTY	NUMBER
STARTING_AUTH_QTY_PRIMARY	NUMBER
STARTING_CUM_QTY_PRIMARY	NUMBER
PURCHASING_UOM_CODE	VARCHAR2	(3)
PURCHASING_UOM_CODE_EXT	VARCHAR2	(50)
SUPPLIER_PRODUCT_NUMBER	VARCHAR2	(25)
SUPPLIER_AGREEMENT_NUMBER	VARCHAR2	(20)
SUPPLIER_AGREEMENT_TYPE	VARCHAR2	(25)
SUPPLIER_AGREEMENT_LINE_NUMBER	NUMBER
SHIP_TO_ORG_ENABLE_CUM_FLAG	VARCHAR2	(1)
SHIP_TO_ORG_CUM_START_DATE	DATE
SHIP_TO_ORG_NAME	VARCHAR2	(240)
SHIP_TO_ORG_CODE	VARCHAR2	(10)
SHIP_TO_ORG_CODE_EXT	VARCHAR2	(50)
SHIP_TO_ORG_LOCATION_CODE	VARCHAR2	(60)
SHIP_TO_ORG_LOCATION_CODE_EXT	VARCHAR2	(60)
SHIP_TO_ORG_ADDRESS_LINE_1	VARCHAR2	(240)
SHIP_TO_ORG_ADDRESS_LINE_2	VARCHAR2	(240)
SHIP_TO_ORG_ADDRESS_LINE_3	VARCHAR2	(240)
SHIP_TO_ORG_CITY	VARCHAR2	(30)
SHIP_TO_ORG_REGION_1	VARCHAR2	(120)
SHIP_TO_ORG_REGION_1_EXT	VARCHAR2	(120)
SHIP_TO_ORG_REGION_2	VARCHAR2	(120)
SHIP_TO_ORG_REGION_2_EXT	VARCHAR2	(120)
SHIP_TO_ORG_REGION_3	VARCHAR2	(120)
SHIP_TO_ORG_REGION_3_EXT	VARCHAR2	(120)
SHIP_TO_ORG_COUNTRY	VARCHAR2	(60)
SHIP_TO_ORG_COUNTRY_EXT	VARCHAR2	(60)
SHIP_TO_ORG_TELEPHONE	VARCHAR2	(60)
SHIP_TO_ORG_POSTAL_CODE	VARCHAR2	(30)
BUYER_LAST_NAME	VARCHAR2	(150)
BUYER_FIRST_NAME	VARCHAR2	(150)
BUYER_WORK_TELEPHONE	VARCHAR2	(60)
ITEM_SCHEDULER_LAST_NAME	VARCHAR2	(150)
ITEM_SCHEDULER_FIRST_NAME	VARCHAR2	(150)
ITEM_SCHEDULER_WORK_TELEPHONE	VARCHAR2	(60)
ITEM_PLANNER_LAST_NAME	VARCHAR2	(150)
ITEM_PLANNER_FIRST_NAME	VARCHAR2	(150)
ITEM_PLANNER_WORK_TELEPHONE	VARCHAR2	(60)
HAZARD_CLASS	VARCHAR2	(40)
HAZARD_CLASS_EXT	VARCHAR2	(50)
HAZARD_CLASS_DESCRIPTION	VARCHAR2	(240)
UN_NUMBER	VARCHAR2	(25)
UN_NUMBER_EXT	VARCHAR2	(50)
SCH_ITEM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SCH_ITEM_ATTRIBUTE1	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE2	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE3	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE4	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE5	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE6	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE7	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE8	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE9	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE10	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE11	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE12	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE13	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE14	VARCHAR2	(150)
SCH_ITEM_ATTRIBUTE15	VARCHAR2	(150)
ITEM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ITEM_ATTRIBUTE1	VARCHAR2	(150)
ITEM_ATTRIBUTE2	VARCHAR2	(150)
ITEM_ATTRIBUTE3	VARCHAR2	(150)
ITEM_ATTRIBUTE4	VARCHAR2	(150)
ITEM_ATTRIBUTE5	VARCHAR2	(150)
ITEM_ATTRIBUTE6	VARCHAR2	(150)
ITEM_ATTRIBUTE7	VARCHAR2	(150)
ITEM_ATTRIBUTE8	VARCHAR2	(150)
ITEM_ATTRIBUTE9	VARCHAR2	(150)
ITEM_ATTRIBUTE10	VARCHAR2	(150)
ITEM_ATTRIBUTE11	VARCHAR2	(150)
ITEM_ATTRIBUTE12	VARCHAR2	(150)
ITEM_ATTRIBUTE13	VARCHAR2	(150)
ITEM_ATTRIBUTE14	VARCHAR2	(150)
ITEM_ATTRIBUTE15	VARCHAR2	(150)
ASL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ASL_ATTRIBUTE1	VARCHAR2	(150)
ASL_ATTRIBUTE2	VARCHAR2	(150)
ASL_ATTRIBUTE3	VARCHAR2	(150)
ASL_ATTRIBUTE4	VARCHAR2	(150)
ASL_ATTRIBUTE5	VARCHAR2	(150)
ASL_ATTRIBUTE6	VARCHAR2	(150)
ASL_ATTRIBUTE7	VARCHAR2	(150)
ASL_ATTRIBUTE8	VARCHAR2	(150)
ASL_ATTRIBUTE9	VARCHAR2	(150)
ASL_ATTRIBUTE10	VARCHAR2	(150)
ASL_ATTRIBUTE11	VARCHAR2	(150)
ASL_ATTRIBUTE12	VARCHAR2	(150)
ASL_ATTRIBUTE13	VARCHAR2	(150)
ASL_ATTRIBUTE14	VARCHAR2	(150)
ASL_ATTRIBUTE15	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ORG_OPT_ATTRIBUTE1	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE2	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE3	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE4	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE5	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE6	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE7	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE8	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE9	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE10	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE11	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE12	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE13	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE14	VARCHAR2	(150)
ORG_OPT_ATTRIBUTE15	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE1	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE2	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE3	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE4	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE5	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE6	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE7	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE8	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE9	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE10	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE11	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE12	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE13	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE14	VARCHAR2	(150)
SHIP_TO_ORG_ATTRIBUTE15	VARCHAR2	(150)
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
CUM_QTY_START_DATE	DATE

Query Text

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


SELECT SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      ITEM_NUMBER
,      PRODUCT_DESCRIPTION
,      STARTING_AUTH_QUANTITY
,      STARTING_CUM_QUANTITY
,      LAST_RECEIPT_SHIPMENT_CODE
,      LAST_RECEIPT_DATE
,      LAST_RECEIPT_QUANTITY
,      LAST_RECEIPT_CUM_QTY
,      STARTING_AUTH_QTY_PRIMARY
,      STARTING_CUM_QTY_PRIMARY
,      PURCHASING_UOM_CODE
,      PURCHASING_UOM_CODE_EXT
,      SUPPLIER_PRODUCT_NUMBER
,      SUPPLIER_AGREEMENT_NUMBER
,      SUPPLIER_AGREEMENT_TYPE
,      SUPPLIER_AGREEMENT_LINE_NUMBER
,      SHIP_TO_ORG_ENABLE_CUM_FLAG
,      SHIP_TO_ORG_CUM_START_DATE
,      SHIP_TO_ORG_NAME
,      SHIP_TO_ORG_CODE
,      SHIP_TO_ORG_CODE_EXT
,      SHIP_TO_ORG_LOCATION_CODE
,      SHIP_TO_ORG_LOCATION_CODE_EXT
,      SHIP_TO_ORG_ADDRESS_LINE_1
,      SHIP_TO_ORG_ADDRESS_LINE_2
,      SHIP_TO_ORG_ADDRESS_LINE_3
,      SHIP_TO_ORG_CITY
,      SHIP_TO_ORG_REGION_1
,      SHIP_TO_ORG_REGION_1_EXT
,      SHIP_TO_ORG_REGION_2
,      SHIP_TO_ORG_REGION_2_EXT
,      SHIP_TO_ORG_REGION_3
,      SHIP_TO_ORG_REGION_3_EXT
,      SHIP_TO_ORG_COUNTRY
,      SHIP_TO_ORG_COUNTRY_EXT
,      SHIP_TO_ORG_TELEPHONE
,      SHIP_TO_ORG_POSTAL_CODE
,      BUYER_LAST_NAME
,      BUYER_FIRST_NAME
,      BUYER_WORK_TELEPHONE
,      ITEM_SCHEDULER_LAST_NAME
,      ITEM_SCHEDULER_FIRST_NAME
,      ITEM_SCHEDULER_WORK_TELEPHONE
,      ITEM_PLANNER_LAST_NAME
,      ITEM_PLANNER_FIRST_NAME
,      ITEM_PLANNER_WORK_TELEPHONE
,      HAZARD_CLASS
,      HAZARD_CLASS_EXT
,      HAZARD_CLASS_DESCRIPTION
,      UN_NUMBER
,      UN_NUMBER_EXT
,      SCH_ITEM_ATTRIBUTE_CATEGORY
,      SCH_ITEM_ATTRIBUTE1
,      SCH_ITEM_ATTRIBUTE2
,      SCH_ITEM_ATTRIBUTE3
,      SCH_ITEM_ATTRIBUTE4
,      SCH_ITEM_ATTRIBUTE5
,      SCH_ITEM_ATTRIBUTE6
,      SCH_ITEM_ATTRIBUTE7
,      SCH_ITEM_ATTRIBUTE8
,      SCH_ITEM_ATTRIBUTE9
,      SCH_ITEM_ATTRIBUTE10
,      SCH_ITEM_ATTRIBUTE11
,      SCH_ITEM_ATTRIBUTE12
,      SCH_ITEM_ATTRIBUTE13
,      SCH_ITEM_ATTRIBUTE14
,      SCH_ITEM_ATTRIBUTE15
,      ITEM_ATTRIBUTE_CATEGORY
,      ITEM_ATTRIBUTE1
,      ITEM_ATTRIBUTE2
,      ITEM_ATTRIBUTE3
,      ITEM_ATTRIBUTE4
,      ITEM_ATTRIBUTE5
,      ITEM_ATTRIBUTE6
,      ITEM_ATTRIBUTE7
,      ITEM_ATTRIBUTE8
,      ITEM_ATTRIBUTE9
,      ITEM_ATTRIBUTE10
,      ITEM_ATTRIBUTE11
,      ITEM_ATTRIBUTE12
,      ITEM_ATTRIBUTE13
,      ITEM_ATTRIBUTE14
,      ITEM_ATTRIBUTE15
,      ASL_ATTRIBUTE_CATEGORY
,      ASL_ATTRIBUTE1
,      ASL_ATTRIBUTE2
,      ASL_ATTRIBUTE3
,      ASL_ATTRIBUTE4
,      ASL_ATTRIBUTE5
,      ASL_ATTRIBUTE6
,      ASL_ATTRIBUTE7
,      ASL_ATTRIBUTE8
,      ASL_ATTRIBUTE9
,      ASL_ATTRIBUTE10
,      ASL_ATTRIBUTE11
,      ASL_ATTRIBUTE12
,      ASL_ATTRIBUTE13
,      ASL_ATTRIBUTE14
,      ASL_ATTRIBUTE15
,      ORG_OPT_ATTRIBUTE_CATEGORY
,      ORG_OPT_ATTRIBUTE1
,      ORG_OPT_ATTRIBUTE2
,      ORG_OPT_ATTRIBUTE3
,      ORG_OPT_ATTRIBUTE4
,      ORG_OPT_ATTRIBUTE5
,      ORG_OPT_ATTRIBUTE6
,      ORG_OPT_ATTRIBUTE7
,      ORG_OPT_ATTRIBUTE8
,      ORG_OPT_ATTRIBUTE9
,      ORG_OPT_ATTRIBUTE10
,      ORG_OPT_ATTRIBUTE11
,      ORG_OPT_ATTRIBUTE12
,      ORG_OPT_ATTRIBUTE13
,      ORG_OPT_ATTRIBUTE14
,      ORG_OPT_ATTRIBUTE15
,      SHIP_TO_ORG_ATTRIBUTE_CATEGORY
,      SHIP_TO_ORG_ATTRIBUTE1
,      SHIP_TO_ORG_ATTRIBUTE2
,      SHIP_TO_ORG_ATTRIBUTE3
,      SHIP_TO_ORG_ATTRIBUTE4
,      SHIP_TO_ORG_ATTRIBUTE5
,      SHIP_TO_ORG_ATTRIBUTE6
,      SHIP_TO_ORG_ATTRIBUTE7
,      SHIP_TO_ORG_ATTRIBUTE8
,      SHIP_TO_ORG_ATTRIBUTE9
,      SHIP_TO_ORG_ATTRIBUTE10
,      SHIP_TO_ORG_ATTRIBUTE11
,      SHIP_TO_ORG_ATTRIBUTE12
,      SHIP_TO_ORG_ATTRIBUTE13
,      SHIP_TO_ORG_ATTRIBUTE14
,      SHIP_TO_ORG_ATTRIBUTE15
,      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
,      CUM_QTY_START_DATE
FROM EC.ECE_SPSO_ITEMS#;

Dependencies

[top of page]

EC.ECE_SPSO_ITEMS# references the following:

EC: ECE_SPSO_ITEMS

EC.ECE_SPSO_ITEMS# is referenced by following:

APPS: ECE_SPSO_ITEMS