[Home] [Help]
[Dependency Information]
Object Name: | ECE_SPSO_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
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.
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) | Yes | 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 | (25) | Supplier Site City | |
SF_STATE | VARCHAR2 | (150) | Supplier Site State | |
SF_ZIP | VARCHAR2 | (20) | Supplier Site Postal Code | |
SF_COUNTRY | VARCHAR2 | (25) | Supplier Site Country | |
SF_PROVINCE | VARCHAR2 | (150) | 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 |
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;
APPS.ECE_SPSO_HEADERS_V is not referenced by any database object
|
|
|