Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: EC.ECE_SPSO_HEADERS#

Object Details
Object Name: ECE_SPSO_HEADERS#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TP_LOCATION_CODE_EXT VARCHAR2 (35)
TP_TRANSLATOR_CODE VARCHAR2 (30)
TP_DESCRIPTION VARCHAR2 (240)
TRANSACTION_DATE DATE

TRANSACTION_CONTROL1 VARCHAR2 (80)
TRANSACTION_CONTROL2 VARCHAR2 (80)
TRANSACTION_CONTROL3 VARCHAR2 (80)
TEST_FLAG VARCHAR2 (1)
TP_REFERENCE_EXT1 VARCHAR2 (240)
TP_REFERENCE_EXT2 VARCHAR2 (240)
COMMUNICATION_METHOD VARCHAR2 (30) Yes
DOCUMENT_ID VARCHAR2 (6)
DOCUMENT_TYPE VARCHAR2 (3)
DOCUMENT_CODE VARCHAR2 (20)
DOCUMENT_PURPOSE_CODE VARCHAR2 (2)
SCHEDULE_ID NUMBER

SCHEDULE_TYPE VARCHAR2 (25)
SCHEDULE_SUB_TYPE VARCHAR2 (25)
SCHEDULE_NUMBER_REVISION VARCHAR2 (30)
SCHEDULE_STATUS VARCHAR2 (25)
SCHEDULE_GENERATION_DATE DATE

FORECAST_HORIZON_START_DATE DATE

FORECAST_HORIZON_END_DATE DATE

MULTIPLE_SHIP_TO_ORG_FLAG VARCHAR2 (1)
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 VARCHAR2 (60)
SHIP_TO_ORG_LOCATION_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_3 VARCHAR2 (120)
SHIP_TO_ORG_REGION_3_EXT VARCHAR2 (120)
SHIP_TO_ORG_REGION_2 VARCHAR2 (120)
SHIP_TO_ORG_REGION_2_EXT VARCHAR2 (120)
SHIP_TO_ORG_COUNTRY VARCHAR2 (60)
SHIP_TO_ORG_COUNTRY_EXT VARCHAR2 (60)
SHIP_TO_ORG_POSTAL_CODE VARCHAR2 (30)
SHIP_TO_ORG_TELEPHONE VARCHAR2 (60)
SUPPLIER_NAME VARCHAR2 (240)
SUPPLIER_SITE_ADDRESS_LINE_4 VARCHAR2 (240)
SUPPLIER_NUMBER VARCHAR2 (30)
SUPPLIER_NUMBER_EXT VARCHAR2 (30)
SUPPLIER_SITE_CODE VARCHAR2 (15)
SUPPLIER_SITE_CODE_EXT VARCHAR2 (50)
SUPPLIER_SITE_ADDRESS_LINE_1 VARCHAR2 (240)
SUPPLIER_SITE_ADDRESS_LINE_2 VARCHAR2 (240)
SUPPLIER_SITE_ADDRESS_LINE_3 VARCHAR2 (240)
SUPPLIER_SITE_CITY VARCHAR2 (25)
SUPPLIER_SITE_STATE VARCHAR2 (150)
SUPPLIER_SITE_STATE_EXT VARCHAR2 (150)
SUPPLIER_SITE_POSTAL_CODE VARCHAR2 (20)
SUPPLIER_SITE_PROVINCE VARCHAR2 (150)
SUPPLIER_SITE_PROVINCE_EXT VARCHAR2 (150)
SUPPLIER_SITE_COUNTRY VARCHAR2 (150)
SUPPLIER_SITE_COUNTRY_EXT VARCHAR2 (150)
SUPPLIER_SITE_AREA_CODE VARCHAR2 (10)
SUPPLIER_SITE_TELEPHONE VARCHAR2 (15)
SCH_HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
SCH_HEADER_ATTRIBUTE1 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE2 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE3 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE4 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE5 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE6 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE7 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE8 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE9 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE10 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE11 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE12 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE13 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE14 VARCHAR2 (150)
SCH_HEADER_ATTRIBUTE15 VARCHAR2 (150)
VENDOR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
VENDOR_ATTRIBUTE1 VARCHAR2 (150)
VENDOR_ATTRIBUTE2 VARCHAR2 (150)
VENDOR_ATTRIBUTE3 VARCHAR2 (150)
VENDOR_ATTRIBUTE4 VARCHAR2 (150)
VENDOR_ATTRIBUTE5 VARCHAR2 (150)
VENDOR_ATTRIBUTE6 VARCHAR2 (150)
VENDOR_ATTRIBUTE7 VARCHAR2 (150)
VENDOR_ATTRIBUTE8 VARCHAR2 (150)
VENDOR_ATTRIBUTE9 VARCHAR2 (150)
VENDOR_ATTRIBUTE10 VARCHAR2 (150)
VENDOR_ATTRIBUTE11 VARCHAR2 (150)
VENDOR_ATTRIBUTE12 VARCHAR2 (150)
VENDOR_ATTRIBUTE13 VARCHAR2 (150)
VENDOR_ATTRIBUTE14 VARCHAR2 (150)
VENDOR_ATTRIBUTE15 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
VENDOR_SITE_ATTRIBUTE1 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE2 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE3 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE4 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE5 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE6 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE7 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE8 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE9 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE10 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE11 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE12 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE13 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE14 VARCHAR2 (150)
VENDOR_SITE_ATTRIBUTE15 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE_CATEGORY VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE1 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE2 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE3 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE4 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE5 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE6 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE7 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE8 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE9 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE10 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE11 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE12 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE13 VARCHAR2 (150)
SHIP_ORG_ATTRIBUTE14 VARCHAR2 (150)
SHIP_ORG_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)
TPH_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TPH_ATTRIBUTE1 VARCHAR2 (150)
TPH_ATTRIBUTE2 VARCHAR2 (150)
TPH_ATTRIBUTE3 VARCHAR2 (150)
TPH_ATTRIBUTE4 VARCHAR2 (150)
TPH_ATTRIBUTE5 VARCHAR2 (150)
TPH_ATTRIBUTE6 VARCHAR2 (150)
TPH_ATTRIBUTE7 VARCHAR2 (150)
TPH_ATTRIBUTE8 VARCHAR2 (150)
TPH_ATTRIBUTE9 VARCHAR2 (150)
TPH_ATTRIBUTE10 VARCHAR2 (150)
TPH_ATTRIBUTE11 VARCHAR2 (150)
TPH_ATTRIBUTE12 VARCHAR2 (150)
TPH_ATTRIBUTE13 VARCHAR2 (150)
TPH_ATTRIBUTE14 VARCHAR2 (150)
TPH_ATTRIBUTE15 VARCHAR2 (150)
TPD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
TPD_ATTRIBUTE1 VARCHAR2 (150)
TPD_ATTRIBUTE2 VARCHAR2 (150)
TPD_ATTRIBUTE3 VARCHAR2 (150)
TPD_ATTRIBUTE4 VARCHAR2 (150)
TPD_ATTRIBUTE5 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

DOCUMENT_STANDARD VARCHAR2 (30)
MAP_ID NUMBER

Query Text

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


SELECT TP_LOCATION_CODE_EXT
,      TP_TRANSLATOR_CODE
,      TP_DESCRIPTION
,      TRANSACTION_DATE
,      TRANSACTION_CONTROL1
,      TRANSACTION_CONTROL2
,      TRANSACTION_CONTROL3
,      TEST_FLAG
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      COMMUNICATION_METHOD
,      DOCUMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_CODE
,      DOCUMENT_PURPOSE_CODE
,      SCHEDULE_ID
,      SCHEDULE_TYPE
,      SCHEDULE_SUB_TYPE
,      SCHEDULE_NUMBER_REVISION
,      SCHEDULE_STATUS
,      SCHEDULE_GENERATION_DATE
,      FORECAST_HORIZON_START_DATE
,      FORECAST_HORIZON_END_DATE
,      MULTIPLE_SHIP_TO_ORG_FLAG
,      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
,      SHIP_TO_ORG_LOCATION_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_3
,      SHIP_TO_ORG_REGION_3_EXT
,      SHIP_TO_ORG_REGION_2
,      SHIP_TO_ORG_REGION_2_EXT
,      SHIP_TO_ORG_COUNTRY
,      SHIP_TO_ORG_COUNTRY_EXT
,      SHIP_TO_ORG_POSTAL_CODE
,      SHIP_TO_ORG_TELEPHONE
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ADDRESS_LINE_4
,      SUPPLIER_NUMBER
,      SUPPLIER_NUMBER_EXT
,      SUPPLIER_SITE_CODE
,      SUPPLIER_SITE_CODE_EXT
,      SUPPLIER_SITE_ADDRESS_LINE_1
,      SUPPLIER_SITE_ADDRESS_LINE_2
,      SUPPLIER_SITE_ADDRESS_LINE_3
,      SUPPLIER_SITE_CITY
,      SUPPLIER_SITE_STATE
,      SUPPLIER_SITE_STATE_EXT
,      SUPPLIER_SITE_POSTAL_CODE
,      SUPPLIER_SITE_PROVINCE
,      SUPPLIER_SITE_PROVINCE_EXT
,      SUPPLIER_SITE_COUNTRY
,      SUPPLIER_SITE_COUNTRY_EXT
,      SUPPLIER_SITE_AREA_CODE
,      SUPPLIER_SITE_TELEPHONE
,      SCH_HEADER_ATTRIBUTE_CATEGORY
,      SCH_HEADER_ATTRIBUTE1
,      SCH_HEADER_ATTRIBUTE2
,      SCH_HEADER_ATTRIBUTE3
,      SCH_HEADER_ATTRIBUTE4
,      SCH_HEADER_ATTRIBUTE5
,      SCH_HEADER_ATTRIBUTE6
,      SCH_HEADER_ATTRIBUTE7
,      SCH_HEADER_ATTRIBUTE8
,      SCH_HEADER_ATTRIBUTE9
,      SCH_HEADER_ATTRIBUTE10
,      SCH_HEADER_ATTRIBUTE11
,      SCH_HEADER_ATTRIBUTE12
,      SCH_HEADER_ATTRIBUTE13
,      SCH_HEADER_ATTRIBUTE14
,      SCH_HEADER_ATTRIBUTE15
,      VENDOR_ATTRIBUTE_CATEGORY
,      VENDOR_ATTRIBUTE1
,      VENDOR_ATTRIBUTE2
,      VENDOR_ATTRIBUTE3
,      VENDOR_ATTRIBUTE4
,      VENDOR_ATTRIBUTE5
,      VENDOR_ATTRIBUTE6
,      VENDOR_ATTRIBUTE7
,      VENDOR_ATTRIBUTE8
,      VENDOR_ATTRIBUTE9
,      VENDOR_ATTRIBUTE10
,      VENDOR_ATTRIBUTE11
,      VENDOR_ATTRIBUTE12
,      VENDOR_ATTRIBUTE13
,      VENDOR_ATTRIBUTE14
,      VENDOR_ATTRIBUTE15
,      VENDOR_SITE_ATTRIBUTE_CATEGORY
,      VENDOR_SITE_ATTRIBUTE1
,      VENDOR_SITE_ATTRIBUTE2
,      VENDOR_SITE_ATTRIBUTE3
,      VENDOR_SITE_ATTRIBUTE4
,      VENDOR_SITE_ATTRIBUTE5
,      VENDOR_SITE_ATTRIBUTE6
,      VENDOR_SITE_ATTRIBUTE7
,      VENDOR_SITE_ATTRIBUTE8
,      VENDOR_SITE_ATTRIBUTE9
,      VENDOR_SITE_ATTRIBUTE10
,      VENDOR_SITE_ATTRIBUTE11
,      VENDOR_SITE_ATTRIBUTE12
,      VENDOR_SITE_ATTRIBUTE13
,      VENDOR_SITE_ATTRIBUTE14
,      VENDOR_SITE_ATTRIBUTE15
,      SHIP_ORG_ATTRIBUTE_CATEGORY
,      SHIP_ORG_ATTRIBUTE1
,      SHIP_ORG_ATTRIBUTE2
,      SHIP_ORG_ATTRIBUTE3
,      SHIP_ORG_ATTRIBUTE4
,      SHIP_ORG_ATTRIBUTE5
,      SHIP_ORG_ATTRIBUTE6
,      SHIP_ORG_ATTRIBUTE7
,      SHIP_ORG_ATTRIBUTE8
,      SHIP_ORG_ATTRIBUTE9
,      SHIP_ORG_ATTRIBUTE10
,      SHIP_ORG_ATTRIBUTE11
,      SHIP_ORG_ATTRIBUTE12
,      SHIP_ORG_ATTRIBUTE13
,      SHIP_ORG_ATTRIBUTE14
,      SHIP_ORG_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
,      TPH_ATTRIBUTE_CATEGORY
,      TPH_ATTRIBUTE1
,      TPH_ATTRIBUTE2
,      TPH_ATTRIBUTE3
,      TPH_ATTRIBUTE4
,      TPH_ATTRIBUTE5
,      TPH_ATTRIBUTE6
,      TPH_ATTRIBUTE7
,      TPH_ATTRIBUTE8
,      TPH_ATTRIBUTE9
,      TPH_ATTRIBUTE10
,      TPH_ATTRIBUTE11
,      TPH_ATTRIBUTE12
,      TPH_ATTRIBUTE13
,      TPH_ATTRIBUTE14
,      TPH_ATTRIBUTE15
,      TPD_ATTRIBUTE_CATEGORY
,      TPD_ATTRIBUTE1
,      TPD_ATTRIBUTE2
,      TPD_ATTRIBUTE3
,      TPD_ATTRIBUTE4
,      TPD_ATTRIBUTE5
,      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
,      DOCUMENT_STANDARD
,      MAP_ID
FROM EC.ECE_SPSO_HEADERS#;

Dependencies

[top of page]

EC.ECE_SPSO_HEADERS# references the following:

SchemaEC
TableECE_SPSO_HEADERS
EC.ECE_SPSO_HEADERS# is referenced by following:

SchemaAPPS
SynonymECE_SPSO_HEADERS