[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_SPSO_ITEMS# |
|---|---|
| Object Type: | VIEW |
| Owner: | EC |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 |
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#;
EC
ECE_SPSO_ITEMS
APPS
ECE_SPSO_ITEMS
|
|
|
|