VIEW: EC.ECE_SPSO_ITEMS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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