[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_SPSO_ITEMS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_SPSO_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
ECE_SPSO_ITEMS contains supplier schedule data to support the
outbound Planning Schedule (830/DELFOR) and Shipping Schedule
(862/DELJIT) transactions.
ECE_SPSO_ITEMS is based primarily on data stored in
CHV_SCHEDULE_ITEMS in Oracle Supplier Scheduling.
ECE_SPSO_ITEMS contains item detail data 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.
In addition, ECE_SPSO_ITEMS contains the scheduling options and
ship-to organization defaults found in CHV_ORG_OPTIONS.
Each row in ECE_SPSO_ITEMS is associated with one row in
ECE_SPSO_HEADERS. There is a one-to-many relationship between
ECE_SPSO_HEADERS and ECE_SPSO_DETAILS.
Each row includes data for the buyer, planner and scheduler of the
item; the item; and the ship-to organization defaults.
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_ITEMS 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_ITEMS is purged after the data is written to the
data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_SPSO_ITEMS table to its corresponding extension table
ECE_SPSO_ITEMS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_SPSO_ITEMS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 SCHEDULE_ITEM_ID
SCHEDULE_ID
RUN_ID
|
| ECE_SPSO_ITEMS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SCHEDULE_ID
RUN_ID
|
| ECE_SPSO_ITEMS_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_RECORD_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHEDULE_ID | NUMBER | Yes | Schedule ID | |
| SCHEDULE_ITEM_ID | NUMBER | Yes | Schedule Item ID | |
| ITEM_NUMBER | VARCHAR2 | (100) | Buyer Product Code | |
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Product Description | |
| STARTING_AUTH_QUANTITY | NUMBER | Purchasing Starting Authorization Quantity | ||
| STARTING_CUM_QUANTITY | NUMBER | Purchasing Starting CUM Quantity | ||
| LAST_RECEIPT_SHIPMENT_CODE | VARCHAR2 | (30) | Last Receipt Shipment Code | |
| LAST_RECEIPT_DATE | DATE | Last Receipt Date | ||
| LAST_RECEIPT_QUANTITY | NUMBER | Last Receipt Quantity | ||
| LAST_RECEIPT_CUM_QTY | NUMBER | CUM Quantity After Last Receipt | ||
| STARTING_AUTH_QTY_PRIMARY | NUMBER | Primary Authorization Quantity | ||
| STARTING_CUM_QTY_PRIMARY | NUMBER | Primary Starting CUM Quantity | ||
| PURCHASING_UOM_CODE | VARCHAR2 | (3) | Purchasing Unit of Measure (Internal) | |
| PURCHASING_UOM_CODE_EXT | VARCHAR2 | (50) | Purchasing Unit of Measure (Ext) | |
| SUPPLIER_PRODUCT_NUMBER | VARCHAR2 | (25) | Supplier Product Code | |
| SUPPLIER_AGREEMENT_NUMBER | VARCHAR2 | (20) | Supply Agreement Number | |
| SUPPLIER_AGREEMENT_TYPE | VARCHAR2 | (25) | Supply Agreement Type | |
| SUPPLIER_AGREEMENT_LINE_NUMBER | NUMBER | Supply Agreement Line Number | ||
| SHIP_TO_ORG_ENABLE_CUM_FLAG | VARCHAR2 | (1) | Ship To Enable CUM Flag | |
| SHIP_TO_ORG_CUM_START_DATE | DATE | Ship To CUM Period Start Date | ||
| SHIP_TO_ORG_NAME | VARCHAR2 | (240) | Ship To Name | |
| SHIP_TO_ORG_CODE | VARCHAR2 | (10) | Ship To Code (Internal) | |
| SHIP_TO_ORG_CODE_EXT | VARCHAR2 | (50) | Ship To Code (Ext) | |
| SHIP_TO_ORG_LOCATION_CODE | VARCHAR2 | (60) | Ship To Location Code | |
| SHIP_TO_ORG_LOCATION_CODE_EXT | VARCHAR2 | (60) | Ship To Location Code (Ext) | |
| SHIP_TO_ORG_ADDRESS_LINE_1 | VARCHAR2 | (240) | Ship To Address Line 1 | |
| SHIP_TO_ORG_ADDRESS_LINE_2 | VARCHAR2 | (240) | Ship To Address Line 2 | |
| SHIP_TO_ORG_ADDRESS_LINE_3 | VARCHAR2 | (240) | Ship To Address Line 3 | |
| SHIP_TO_ORG_CITY | VARCHAR2 | (30) | Ship To City | |
| SHIP_TO_ORG_REGION_1 | VARCHAR2 | (120) | Ship To Region 1 (Internal) | |
| SHIP_TO_ORG_REGION_1_EXT | VARCHAR2 | (120) | Ship To Region 1 (Ext) | |
| SHIP_TO_ORG_REGION_2 | VARCHAR2 | (120) | Ship To Region 2 (Internal) | |
| SHIP_TO_ORG_REGION_2_EXT | VARCHAR2 | (120) | Ship To Region 2 (Ext) | |
| SHIP_TO_ORG_REGION_3 | VARCHAR2 | (120) | Ship To Region 3 (Internal) | |
| SHIP_TO_ORG_REGION_3_EXT | VARCHAR2 | (120) | Ship To Region 3 (Ext) | |
| SHIP_TO_ORG_COUNTRY | VARCHAR2 | (60) | Ship To Country (Internal) | |
| SHIP_TO_ORG_COUNTRY_EXT | VARCHAR2 | (60) | Ship To Country (Ext) | |
| SHIP_TO_ORG_TELEPHONE | VARCHAR2 | (60) | Ship To Telephone | |
| SHIP_TO_ORG_POSTAL_CODE | VARCHAR2 | (30) | Ship To Postal Code | |
| BUYER_LAST_NAME | VARCHAR2 | (150) | Buyer - Last Name | |
| BUYER_FIRST_NAME | VARCHAR2 | (150) | Buyer - First Name | |
| BUYER_WORK_TELEPHONE | VARCHAR2 | (60) | Buyer - Work Telephone | |
| ITEM_SCHEDULER_LAST_NAME | VARCHAR2 | (150) | Item Scheduler - Last Name | |
| ITEM_SCHEDULER_FIRST_NAME | VARCHAR2 | (150) | Item Scheduler - First Name | |
| ITEM_SCHEDULER_WORK_TELEPHONE | VARCHAR2 | (60) | Item Scheduler - Work Telephone | |
| ITEM_PLANNER_LAST_NAME | VARCHAR2 | (150) | Item Planner - Last Name | |
| ITEM_PLANNER_FIRST_NAME | VARCHAR2 | (150) | Item Planner - First Name | |
| ITEM_PLANNER_WORK_TELEPHONE | VARCHAR2 | (60) | Item Planner - Work Telephone | |
| HAZARD_CLASS | VARCHAR2 | (40) | Hazard Class (Internal) | |
| HAZARD_CLASS_EXT | VARCHAR2 | (50) | Hazard Class (Ext) | |
| HAZARD_CLASS_DESCRIPTION | VARCHAR2 | (240) | Hazard Class Description | |
| UN_NUMBER | VARCHAR2 | (25) | Hazard Material Code (Internal) | |
| UN_NUMBER_EXT | VARCHAR2 | (50) | Hazard Material (Ext) | |
| SCH_ITEM_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Schedule Item Flexfield Context | |
| SCH_ITEM_ATTRIBUTE1 | VARCHAR2 | (150) | Schedule Item Flexfield 1 | |
| SCH_ITEM_ATTRIBUTE2 | VARCHAR2 | (150) | Schedule Item Flexfield 2 | |
| SCH_ITEM_ATTRIBUTE3 | VARCHAR2 | (150) | Schedule Item Flexfield 3 | |
| SCH_ITEM_ATTRIBUTE4 | VARCHAR2 | (150) | Schedule Item Flexfield 4 | |
| SCH_ITEM_ATTRIBUTE5 | VARCHAR2 | (150) | Schedule Item Flexfield 5 | |
| SCH_ITEM_ATTRIBUTE6 | VARCHAR2 | (150) | Schedule Item Flexfield 6 | |
| SCH_ITEM_ATTRIBUTE7 | VARCHAR2 | (150) | Schedule Item Flexfield 7 | |
| SCH_ITEM_ATTRIBUTE8 | VARCHAR2 | (150) | Schedule Item Flexfield 8 | |
| SCH_ITEM_ATTRIBUTE9 | VARCHAR2 | (150) | Schedule Item Flexfield 9 | |
| SCH_ITEM_ATTRIBUTE10 | VARCHAR2 | (150) | Schedule Item Flexfield 10 | |
| SCH_ITEM_ATTRIBUTE11 | VARCHAR2 | (150) | Schedule Item Flexfield 11 | |
| SCH_ITEM_ATTRIBUTE12 | VARCHAR2 | (150) | Schedule Item Flexfield 12 | |
| SCH_ITEM_ATTRIBUTE13 | VARCHAR2 | (150) | Schedule Item Flexfield 13 | |
| SCH_ITEM_ATTRIBUTE14 | VARCHAR2 | (150) | Schedule Item Flexfield 14 | |
| SCH_ITEM_ATTRIBUTE15 | VARCHAR2 | (150) | Schedule Item Flexfield 15 | |
| ITEM_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Item Flexfield Context | |
| ITEM_ATTRIBUTE1 | VARCHAR2 | (150) | Item Flexfield 1 | |
| ITEM_ATTRIBUTE2 | VARCHAR2 | (150) | Item Flexfield 2 | |
| ITEM_ATTRIBUTE3 | VARCHAR2 | (150) | Item Flexfield 3 | |
| ITEM_ATTRIBUTE4 | VARCHAR2 | (150) | Item Flexfield 4 | |
| ITEM_ATTRIBUTE5 | VARCHAR2 | (150) | Item Flexfield 5 | |
| ITEM_ATTRIBUTE6 | VARCHAR2 | (150) | Item Flexfield 6 | |
| ITEM_ATTRIBUTE7 | VARCHAR2 | (150) | Item Flexfield 7 | |
| ITEM_ATTRIBUTE8 | VARCHAR2 | (150) | Item Flexfield 8 | |
| ITEM_ATTRIBUTE9 | VARCHAR2 | (150) | Item Flexfield 9 | |
| ITEM_ATTRIBUTE10 | VARCHAR2 | (150) | Item Flexfield 10 | |
| ITEM_ATTRIBUTE11 | VARCHAR2 | (150) | Item Flexfield 11 | |
| ITEM_ATTRIBUTE12 | VARCHAR2 | (150) | Item Flexfield 12 | |
| ITEM_ATTRIBUTE13 | VARCHAR2 | (150) | Item Flexfield 13 | |
| ITEM_ATTRIBUTE14 | VARCHAR2 | (150) | Item Flexfield 14 | |
| ITEM_ATTRIBUTE15 | VARCHAR2 | (150) | Item Flexfield 15 | |
| ASL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Approved Supplier List Flexfield Context | |
| ASL_ATTRIBUTE1 | VARCHAR2 | (150) | Approved Supplier List Flexfield 1 | |
| ASL_ATTRIBUTE2 | VARCHAR2 | (150) | Approved Supplier List Flexfield 2 | |
| ASL_ATTRIBUTE3 | VARCHAR2 | (150) | Approved Supplier List Flexfield 3 | |
| ASL_ATTRIBUTE4 | VARCHAR2 | (150) | Approved Supplier List Flexfield 4 | |
| ASL_ATTRIBUTE5 | VARCHAR2 | (150) | Approved Supplier List Flexfield 5 | |
| ASL_ATTRIBUTE6 | VARCHAR2 | (150) | Approved Supplier List Flexfield 6 | |
| ASL_ATTRIBUTE7 | VARCHAR2 | (150) | Approved Supplier List Flexfield 7 | |
| ASL_ATTRIBUTE8 | VARCHAR2 | (150) | Approved Supplier List Flexfield 8 | |
| ASL_ATTRIBUTE9 | VARCHAR2 | (150) | Approved Supplier List Flexfield 9 | |
| ASL_ATTRIBUTE10 | VARCHAR2 | (150) | Approved Supplier List Flexfield 10 | |
| ASL_ATTRIBUTE11 | VARCHAR2 | (150) | Approved Supplier List Flexfield 11 | |
| ASL_ATTRIBUTE12 | VARCHAR2 | (150) | Approved Supplier List Flexfield 12 | |
| ASL_ATTRIBUTE13 | VARCHAR2 | (150) | Approved Supplier List Flexfield 13 | |
| ASL_ATTRIBUTE14 | VARCHAR2 | (150) | Approved Supplier List Flexfield 14 | |
| ASL_ATTRIBUTE15 | VARCHAR2 | (150) | Approved Supplier List Flexfield 15 | |
| ORG_OPT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Ship To Options Flexfield Context | |
| ORG_OPT_ATTRIBUTE1 | VARCHAR2 | (150) | Ship To Options Flexfield 1 | |
| ORG_OPT_ATTRIBUTE2 | VARCHAR2 | (150) | Ship To Options Flexfield 2 | |
| ORG_OPT_ATTRIBUTE3 | VARCHAR2 | (150) | Ship To Options Flexfield 3 | |
| ORG_OPT_ATTRIBUTE4 | VARCHAR2 | (150) | Ship To Options Flexfield 4 | |
| ORG_OPT_ATTRIBUTE5 | VARCHAR2 | (150) | Ship To Options Flexfield 5 | |
| ORG_OPT_ATTRIBUTE6 | VARCHAR2 | (150) | Ship To Options Flexfield 6 | |
| ORG_OPT_ATTRIBUTE7 | VARCHAR2 | (150) | Ship To Options Flexfield 7 | |
| ORG_OPT_ATTRIBUTE8 | VARCHAR2 | (150) | Ship To Options Flexfield 8 | |
| ORG_OPT_ATTRIBUTE9 | VARCHAR2 | (150) | Ship To Options Flexfield 9 | |
| ORG_OPT_ATTRIBUTE10 | VARCHAR2 | (150) | Ship To Options Flexfield 10 | |
| ORG_OPT_ATTRIBUTE11 | VARCHAR2 | (150) | Ship To Options Flexfield 11 | |
| ORG_OPT_ATTRIBUTE12 | VARCHAR2 | (150) | Ship To Options Flexfield 12 | |
| ORG_OPT_ATTRIBUTE13 | VARCHAR2 | (150) | Ship To Options Flexfield 13 | |
| ORG_OPT_ATTRIBUTE14 | VARCHAR2 | (150) | Ship To Options Flexfield 14 | |
| ORG_OPT_ATTRIBUTE15 | VARCHAR2 | (150) | Ship To Options Flexfield 15 | |
| SHIP_TO_ORG_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Ship To Flexfield Context | |
| SHIP_TO_ORG_ATTRIBUTE1 | VARCHAR2 | (150) | Ship To Flexfield 1 | |
| SHIP_TO_ORG_ATTRIBUTE2 | VARCHAR2 | (150) | Ship To Flexfield 2 | |
| SHIP_TO_ORG_ATTRIBUTE3 | VARCHAR2 | (150) | Ship To Flexfield 3 | |
| SHIP_TO_ORG_ATTRIBUTE4 | VARCHAR2 | (150) | Ship To Flexfield 4 | |
| SHIP_TO_ORG_ATTRIBUTE5 | VARCHAR2 | (150) | Ship To Flexfield 5 | |
| SHIP_TO_ORG_ATTRIBUTE6 | VARCHAR2 | (150) | Ship To Flexfield 6 | |
| SHIP_TO_ORG_ATTRIBUTE7 | VARCHAR2 | (150) | Ship To Flexfield 7 | |
| SHIP_TO_ORG_ATTRIBUTE8 | VARCHAR2 | (150) | Ship To Flexfield 8 | |
| SHIP_TO_ORG_ATTRIBUTE9 | VARCHAR2 | (150) | Ship To Flexfield 9 | |
| SHIP_TO_ORG_ATTRIBUTE10 | VARCHAR2 | (150) | Ship To Flexfield 10 | |
| SHIP_TO_ORG_ATTRIBUTE11 | VARCHAR2 | (150) | Ship To Flexfield 11 | |
| SHIP_TO_ORG_ATTRIBUTE12 | VARCHAR2 | (150) | Ship To Flexfield 12 | |
| SHIP_TO_ORG_ATTRIBUTE13 | VARCHAR2 | (150) | Ship To Flexfield 13 | |
| SHIP_TO_ORG_ATTRIBUTE14 | VARCHAR2 | (150) | Ship To Flexfield 14 | |
| SHIP_TO_ORG_ATTRIBUTE15 | VARCHAR2 | (150) | Ship To Flexfield 15 | |
| RUN_ID | NUMBER | Run ID | ||
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links the transaction base table to its associated extension table. | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED__BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| CUM_QTY_START_DATE | DATE | CUM Quantity Start 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 does not reference any database object
EC.ECE_SPSO_ITEMS is referenced by following:
APPS
ECE_SPSO_ITEMS
|
|
|
|