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


VIEW: APPS.ECE_SPSO_HEADERS_V

Object Details
Object Name: ECE_SPSO_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_SPSO_HEADERS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view extracts header information
for the outbound Planning Schedule (830/DELFOR) transaction.

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMMUNICATION_METHOD VARCHAR2 (25)
Transaction Method
TEST_FLAG VARCHAR2 (1) Yes Test Indicator
DOCUMENT_ID CHAR (4)
Document ID
DOCUMENT_TYPE CHAR (3)
Document Type
DOCUMENT_CODE VARCHAR2 (20)
Document Code
TP_TRANSLATOR_CODE VARCHAR2 (30)
Trading Partner Translator Code
TP_LOCATION_CODE_EXT VARCHAR2 (60)
Trading Partner Location Code
TP_DESCRIPTION VARCHAR2 (240)
Trading Partner Description
TP_REFERENCE_EXT1 VARCHAR2 (240)
Trading Partner Reference 1 (Ext)
TP_REFERENCE_EXT2 VARCHAR2 (240)
Trading Partner Reference 2 (Ext)
TPH_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TP Flexfield Context
TPH_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Flexfield 1
TPH_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Flexfield 2
TPH_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Flexfield 3
TPH_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Flexfield 4
TPH_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Flexfield 5
TPH_ATTRIBUTE6 VARCHAR2 (150)
Trading Partner Flexfield 6
TPH_ATTRIBUTE7 VARCHAR2 (150)
Trading Partner Flexfield 7
TPH_ATTRIBUTE8 VARCHAR2 (150)
Trading Partner Flexfield 8
TPH_ATTRIBUTE9 VARCHAR2 (150)
Trading Partner Flexfield 9
TPH_ATTRIBUTE10 VARCHAR2 (150)
Trading Partner Flexfield 10
TPH_ATTRIBUTE11 VARCHAR2 (150)
Trading Partner Flexfield 11
TPH_ATTRIBUTE12 VARCHAR2 (150)
Trading Partner Flexfield 12
TPH_ATTRIBUTE13 VARCHAR2 (150)
Trading Partner Flexfield 13
TPH_ATTRIBUTE14 VARCHAR2 (150)
Trading Partner Flexfield 14
TPH_ATTRIBUTE15 VARCHAR2 (150)
Trading Partner Flexfield 15
TPD_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Trading Partner Detail Flexfield Context
TPD_ATTRIBUTE1 VARCHAR2 (150)
Trading Partner Detail Flexfield 1
TPD_ATTRIBUTE2 VARCHAR2 (150)
Trading Partner Detail Flexfield 2
TPD_ATTRIBUTE3 VARCHAR2 (150)
Trading Partner Detail Flexfield 3
TPD_ATTRIBUTE4 VARCHAR2 (150)
Trading Partner Detail Flexfield 4
TPD_ATTRIBUTE5 VARCHAR2 (150)
Trading Partner Detail Flexfield 5
SCHEDULE_HORIZON_START DATE
Yes Forecast Horizon Start Date
SCHEDULE_HORIZON_END DATE
Yes Forecast Horizon End Date
CREATION_DATE DATE
Yes Schedule Generation Date
ORGANIZATION_ID NUMBER

Ship To Organization ID
VENDOR_ID NUMBER
Yes Supplier ID
VENDOR_SITE_ID NUMBER
Yes Supplier Site ID
SCHEDULE_ID NUMBER
Yes Schedule ID
SCHEDULE_TYPE VARCHAR2 (25) Yes Schedule Type
SCHEDULE_SUBTYPE VARCHAR2 (25) Yes Schedule Sub Type
SCHEDULE_STATUS VARCHAR2 (25)
Schedule Status
SCHEDULE_NUMBER_REVISION VARCHAR2 (61)
Schedule Revision
SF_NAME VARCHAR2 (240)
Supplier Name
SF_NUMBER VARCHAR2 (30) Yes Supplier Number (Ext)
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier Site Code (Ext)
SF_ADDRESS_LINE1 VARCHAR2 (240)
Supplier Site Address Line 1
SF_ADDRESS_LINE2 VARCHAR2 (240)
Supplier Site Address Line 2
SF_ADDRESS_LINE3 VARCHAR2 (240)
Supplier Site Address Line 3
SF_CITY VARCHAR2 (60)
Supplier Site City
SF_STATE VARCHAR2 (60)
Supplier Site State
SF_ZIP VARCHAR2 (20)
Supplier Site Postal Code
SF_COUNTRY VARCHAR2 (25)
Supplier Site Country
SF_PROVINCE VARCHAR2 (60)
Supplier Site Province
SF_AREA_CODE VARCHAR2 (10)
Supplier Site Area Code
SF_PHONE VARCHAR2 (15)
Supplier Site Telephone
ST_NAME VARCHAR2 (240)
Ship To Name
ST_ORG_CODE VARCHAR2 (3)
Ship To Organization Code (Ext 1)
MULTIPLE_SHIP_TO_ORG_FLAG VARCHAR2 (1)
Multiple ship to org Flag
ST_LOCATION_CODE VARCHAR2 (60)
Ship To Code (Ext)
ST_ADDRESS_LINE1 VARCHAR2 (240)
Ship To Address Line 1
ST_ADDRESS_LINE2 VARCHAR2 (240)
Ship To Address Line 2
ST_ADDRESS_LINE3 VARCHAR2 (240)
Ship To Address Line 3
ST_CITY VARCHAR2 (30)
Ship To City
ST_STATE VARCHAR2 (120)
Ship To Region 2 (Ext 1)
ST_COUNTY VARCHAR2 (120)
Ship To Region 2 (Ext 1)
ST_POSTAL_CODE VARCHAR2 (30)
Ship To Postal Code
ST_COUNTRY VARCHAR2 (60)
Ship To Country (Ext 1)
ST_REGION3 VARCHAR2 (120)
Ship To Region 3 (Ext 1)
ST_TELEPHONE VARCHAR2 (60)
Ship To Telephone
ENABLE_CUM_FLAG VARCHAR2 (1)
Ship To Ship To Organization Enable CUM Flag
CUM_PERIOD_START_DATE DATE

Ship To Organization CUM Period Start Date
SCH_HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Schedule Header Flexfield Context
SCH_HEADER_ATTRIBUTE1 VARCHAR2 (150)
Schedule Header Flexfield 1
SCH_HEADER_ATTRIBUTE2 VARCHAR2 (150)
Schedule Header Flexfield 2
SCH_HEADER_ATTRIBUTE3 VARCHAR2 (150)
Schedule Header Flexfield 3
SCH_HEADER_ATTRIBUTE4 VARCHAR2 (150)
Schedule Header Flexfield 4
SCH_HEADER_ATTRIBUTE5 VARCHAR2 (150)
Schedule Header Flexfield 5
SCH_HEADER_ATTRIBUTE6 VARCHAR2 (150)
Schedule Header Flexfield 6
SCH_HEADER_ATTRIBUTE7 VARCHAR2 (150)
Schedule Header Flexfield 7
SCH_HEADER_ATTRIBUTE8 VARCHAR2 (150)
Schedule Header Flexfield 8
SCH_HEADER_ATTRIBUTE9 VARCHAR2 (150)
Schedule Header Flexfield 9
SCH_HEADER_ATTRIBUTE10 VARCHAR2 (150)
Schedule Header Flexfield 10
SCH_HEADER_ATTRIBUTE11 VARCHAR2 (150)
Schedule Header Flexfield 11
SCH_HEADER_ATTRIBUTE12 VARCHAR2 (150)
Schedule Header Flexfield 12
SCH_HEADER_ATTRIBUTE13 VARCHAR2 (150)
Schedule Header Flexfield 13
SCH_HEADER_ATTRIBUTE14 VARCHAR2 (150)
Schedule Header Flexfield 14
SCH_HEADER_ATTRIBUTE15 VARCHAR2 (150)
Schedule Header Flexfield 15
VENDOR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Supplier Flexfield Context
VENDOR_ATTRIBUTE1 VARCHAR2 (150)
Supplier Flexfield 1
VENDOR_ATTRIBUTE2 VARCHAR2 (150)
Supplier Flexfield 2
VENDOR_ATTRIBUTE3 VARCHAR2 (150)
Supplier Flexfield 3
VENDOR_ATTRIBUTE4 VARCHAR2 (150)
Supplier Flexfield 4
VENDOR_ATTRIBUTE5 VARCHAR2 (150)
Supplier Flexfield 5
VENDOR_ATTRIBUTE6 VARCHAR2 (150)
Supplier Flexfield 6
VENDOR_ATTRIBUTE7 VARCHAR2 (150)
Supplier Flexfield 7
VENDOR_ATTRIBUTE8 VARCHAR2 (150)
Supplier Flexfield 8
VENDOR_ATTRIBUTE9 VARCHAR2 (150)
Supplier Flexfield 9
VENDOR_ATTRIBUTE10 VARCHAR2 (150)
Supplier Flexfield 10
VENDOR_ATTRIBUTE11 VARCHAR2 (150)
Supplier Flexfield 11
VENDOR_ATTRIBUTE12 VARCHAR2 (150)
Supplier Flexfield 12
VENDOR_ATTRIBUTE13 VARCHAR2 (150)
Supplier Flexfield 13
VENDOR_ATTRIBUTE14 VARCHAR2 (150)
Supplier Flexfield 14
VENDOR_ATTRIBUTE15 VARCHAR2 (150)
Supplier Flexfield 15
VNS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Supplier Site Flexfield Context
VNS_ATTRIBUTE1 VARCHAR2 (150)
Supplier Site Flexfield 1
VNS_ATTRIBUTE2 VARCHAR2 (150)
Supplier Site Flexfield 2
VNS_ATTRIBUTE3 VARCHAR2 (150)
Supplier Site Flexfield 3
VNS_ATTRIBUTE4 VARCHAR2 (150)
Supplier Site Flexfield 4
VNS_ATTRIBUTE5 VARCHAR2 (150)
Supplier Site Flexfield 5
VNS_ATTRIBUTE6 VARCHAR2 (150)
Supplier Site Flexfield 6
VNS_ATTRIBUTE7 VARCHAR2 (150)
Supplier Site Flexfield 7
VNS_ATTRIBUTE8 VARCHAR2 (150)
Supplier Site Flexfield 8
VNS_ATTRIBUTE9 VARCHAR2 (150)
Supplier Site Flexfield 9
VNS_ATTRIBUTE10 VARCHAR2 (150)
Supplier Site Flexfield 10
VNS_ATTRIBUTE11 VARCHAR2 (150)
Supplier Site Flexfield 11
VNS_ATTRIBUTE12 VARCHAR2 (150)
Supplier Site Flexfield 12
VNS_ATTRIBUTE13 VARCHAR2 (150)
Supplier Site Flexfield 13
VNS_ATTRIBUTE14 VARCHAR2 (150)
Supplier Site Flexfield 14
VNS_ATTRIBUTE15 VARCHAR2 (150)
Supplier Site Flexfield 15
SHIP_ORG_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Ship To Flexfield Context
SHIP_ORG_ATTRIBUTE1 VARCHAR2 (150)
Ship To Flexfield 1
SHIP_ORG_ATTRIBUTE2 VARCHAR2 (150)
Ship To Flexfield 2
SHIP_ORG_ATTRIBUTE3 VARCHAR2 (150)
Ship To Flexfield 3
SHIP_ORG_ATTRIBUTE4 VARCHAR2 (150)
Ship To Flexfield 4
SHIP_ORG_ATTRIBUTE5 VARCHAR2 (150)
Ship To Flexfield 5
SHIP_ORG_ATTRIBUTE6 VARCHAR2 (150)
Ship To Flexfield 6
SHIP_ORG_ATTRIBUTE7 VARCHAR2 (150)
Ship To Flexfield 7
SHIP_ORG_ATTRIBUTE8 VARCHAR2 (150)
Ship To Flexfield 8
SHIP_ORG_ATTRIBUTE9 VARCHAR2 (150)
Ship To Flexfield 9
SHIP_ORG_ATTRIBUTE10 VARCHAR2 (150)
Ship To Flexfield 10
SHIP_ORG_ATTRIBUTE11 VARCHAR2 (150)
Ship To Flexfield 11
SHIP_ORG_ATTRIBUTE12 VARCHAR2 (150)
Ship To Flexfield 12
SHIP_ORG_ATTRIBUTE13 VARCHAR2 (150)
Ship To Flexfield 13
SHIP_ORG_ATTRIBUTE14 VARCHAR2 (150)
Ship To Flexfield 14
SHIP_ORG_ATTRIBUTE15 VARCHAR2 (150)
Ship To 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
TRANSACTION_DATE DATE

Transaction Date/Time
RUN_ID NUMBER

Transaction Run ID
DOCUMENT_STANDARD VARCHAR2 (30)
EDI Document Standard
MAP_ID NUMBER (15)
Transaction Map ID
BATCH_ID NUMBER
Yes Batch ID
Query Text

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


SELECT COMMUNICATION_METHOD
,      TEST_FLAG
,      DOCUMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_CODE
,      TP_TRANSLATOR_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      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
,      SCHEDULE_HORIZON_START
,      SCHEDULE_HORIZON_END
,      CREATION_DATE
,      ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SCHEDULE_ID
,      SCHEDULE_TYPE
,      SCHEDULE_SUBTYPE
,      SCHEDULE_STATUS
,      SCHEDULE_NUMBER_REVISION
,      SF_NAME
,      SF_NUMBER
,      VENDOR_SITE_CODE
,      SF_ADDRESS_LINE1
,      SF_ADDRESS_LINE2
,      SF_ADDRESS_LINE3
,      SF_CITY
,      SF_STATE
,      SF_ZIP
,      SF_COUNTRY
,      SF_PROVINCE
,      SF_AREA_CODE
,      SF_PHONE
,      ST_NAME
,      ST_ORG_CODE
,      MULTIPLE_SHIP_TO_ORG_FLAG
,      ST_LOCATION_CODE
,      ST_ADDRESS_LINE1
,      ST_ADDRESS_LINE2
,      ST_ADDRESS_LINE3
,      ST_CITY
,      ST_STATE
,      ST_COUNTY
,      ST_POSTAL_CODE
,      ST_COUNTRY
,      ST_REGION3
,      ST_TELEPHONE
,      ENABLE_CUM_FLAG
,      CUM_PERIOD_START_DATE
,      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
,      VNS_ATTRIBUTE_CATEGORY
,      VNS_ATTRIBUTE1
,      VNS_ATTRIBUTE2
,      VNS_ATTRIBUTE3
,      VNS_ATTRIBUTE4
,      VNS_ATTRIBUTE5
,      VNS_ATTRIBUTE6
,      VNS_ATTRIBUTE7
,      VNS_ATTRIBUTE8
,      VNS_ATTRIBUTE9
,      VNS_ATTRIBUTE10
,      VNS_ATTRIBUTE11
,      VNS_ATTRIBUTE12
,      VNS_ATTRIBUTE13
,      VNS_ATTRIBUTE14
,      VNS_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
,      TRANSACTION_DATE
,      RUN_ID
,      DOCUMENT_STANDARD
,      MAP_ID
,      BATCH_ID
FROM APPS.ECE_SPSO_HEADERS_V;

Dependencies

[top of page]

APPS.ECE_SPSO_HEADERS_V references the following:

SchemaAPPS
SynonymCHV_CUM_PERIODS
SynonymCHV_ITEM_ORDERS
SynonymCHV_ORG_OPTIONS
SynonymCHV_SCHEDULE_HEADERS
SynonymECE_TP_DETAILS
SynonymECE_TP_HEADERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES

APPS.ECE_SPSO_HEADERS_V is not referenced by any database object