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


VIEW: APPS.ECE_SSSO_ITEMS_V

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

View Type

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


This view extracts item information for the outbound Shipping Schedule (862/DELJIT) transaction.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER
Yes Schedule ID
SCHEDULE_ITEM_ID NUMBER
Yes Schedule Item ID
ITEM_ID NUMBER
Yes Item ID
ITEM_NUMBER VARCHAR2 (40)
Buyer Product Code
DESCRIPTION VARCHAR2 (240)
Product Description
PO_UOM VARCHAR2 (3)
Purchasing Unit of Measure (Internal)
SUPPLY_AGREEMENT_NUMBER VARCHAR2 (20)
Supply Agreement Number
SUPPLY_AGREEMENT_TYPE VARCHAR2 (25)
Supply Agreement Type
SUPPLY_AGREEMENT_LINE_NUMBER NUMBER

Supply Agreement Line Number
ENABLE_CUM_FLAG VARCHAR2 (1) Yes Ship To Org Enable CUM Flag
CUM_PERIOD_START_DATE DATE

CUM Period Start Date
ST_NAME VARCHAR2 (240)
Ship To Name
ST_ORG_CODE VARCHAR2 (3)
Ship To Code (Internal)
ST_LOCATION_CODE VARCHAR2 (60)
Ship To Location Code
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_COUNTY VARCHAR2 (120)
Ship To Region 1 (Internal)
ST_STATE VARCHAR2 (120)
Ship To Region 2 (Internal)
ST_REGION3 VARCHAR2 (120)
Ship To Region 3 (Internal)
ST_COUNTRY VARCHAR2 (60)
Ship To Country (Internal)
ST_POSTAL_CODE VARCHAR2 (30)
Ship To Postal Code
ST_TELEPHONE VARCHAR2 (60)
Ship To Telephone
BUYER_LAST_NAME VARCHAR2 (150)
Buyer Last Name
BUYER_FIRST_NAME VARCHAR2 (150)
Buyer First Name
BUYER_TELEPHONE VARCHAR2 (60)
Buyer Work Telephone
HAZARD_CLASS VARCHAR2 (40)
Hazard Class (Internal)
HAZARD_CLASS_DESCRIPTION VARCHAR2 (240)
Hazard Class Description
UN_NUMBER VARCHAR2 (25)
Hazard Material Code (Internal)
STARTING_AUTH_QUANTITY NUMBER

Purchasing Starting Authorization Quantity
STARTING_CUM_QUANTITY NUMBER

Purchasing Starting CUM Quantity
STARTING_AUTH_QTY_PRIMARY NUMBER

Primary Authorization Quantity
STARTING_CUM_QTY_PRIMARY NUMBER

Primary Starting CUM Quantity
LAST_RECEIPT_TRANSACTION_ID NUMBER

Last Receipt Transaction ID
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 (240)
Item Flexfield 1
ITEM_ATTRIBUTE2 VARCHAR2 (240)
Item Flexfield 2
ITEM_ATTRIBUTE3 VARCHAR2 (240)
Item Flexfield 3
ITEM_ATTRIBUTE4 VARCHAR2 (240)
Item Flexfield 4
ITEM_ATTRIBUTE5 VARCHAR2 (240)
Item Flexfield 5
ITEM_ATTRIBUTE6 VARCHAR2 (240)
Item Flexfield 6
ITEM_ATTRIBUTE7 VARCHAR2 (240)
Item Flexfield 7
ITEM_ATTRIBUTE8 VARCHAR2 (240)
Item Flexfield 8
ITEM_ATTRIBUTE9 VARCHAR2 (240)
Item Flexfield 9
ITEM_ATTRIBUTE10 VARCHAR2 (240)
Item Flexfield 10
ITEM_ATTRIBUTE11 VARCHAR2 (240)
Item Flexfield 11
ITEM_ATTRIBUTE12 VARCHAR2 (240)
Item Flexfield 12
ITEM_ATTRIBUTE13 VARCHAR2 (240)
Item Flexfield 13
ITEM_ATTRIBUTE14 VARCHAR2 (240)
Item Flexfield 14
ITEM_ATTRIBUTE15 VARCHAR2 (240)
Item Flexfield 15
SHIP_TO_ORG_ATTRIBUTE_CATEGORY VARCHAR2 (30)
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
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
RUN_ID NUMBER

Transaction Run ID
Query Text

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


SELECT SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      ITEM_ID
,      ITEM_NUMBER
,      DESCRIPTION
,      PO_UOM
,      SUPPLY_AGREEMENT_NUMBER
,      SUPPLY_AGREEMENT_TYPE
,      SUPPLY_AGREEMENT_LINE_NUMBER
,      ENABLE_CUM_FLAG
,      CUM_PERIOD_START_DATE
,      ST_NAME
,      ST_ORG_CODE
,      ST_LOCATION_CODE
,      ST_ADDRESS_LINE1
,      ST_ADDRESS_LINE2
,      ST_ADDRESS_LINE3
,      ST_CITY
,      ST_COUNTY
,      ST_STATE
,      ST_REGION3
,      ST_COUNTRY
,      ST_POSTAL_CODE
,      ST_TELEPHONE
,      BUYER_LAST_NAME
,      BUYER_FIRST_NAME
,      BUYER_TELEPHONE
,      HAZARD_CLASS
,      HAZARD_CLASS_DESCRIPTION
,      UN_NUMBER
,      STARTING_AUTH_QUANTITY
,      STARTING_CUM_QUANTITY
,      STARTING_AUTH_QTY_PRIMARY
,      STARTING_CUM_QTY_PRIMARY
,      LAST_RECEIPT_TRANSACTION_ID
,      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
,      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
,      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
,      RUN_ID
FROM APPS.ECE_SSSO_ITEMS_V;

Dependencies

[top of page]

APPS.ECE_SSSO_ITEMS_V references the following:

SchemaAPPS
SynonymCHV_CUM_PERIODS
SynonymCHV_ITEM_ORDERS
SynonymCHV_ORG_OPTIONS
SynonymCHV_SCHEDULE_HEADERS
SynonymCHV_SCHEDULE_ITEMS
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
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_PARAMETERS
SynonymMTL_UNITS_OF_MEASURE
SynonymPER_ALL_PEOPLE_F
SynonymPER_PHONES
SynonymPO_HAZARD_CLASSES_B
SynonymPO_HAZARD_CLASSES_TL
SynonymPO_HEADERS
SynonymPO_LINES
SynonymPO_UN_NUMBERS_B
SynonymPO_UN_NUMBERS_TL

APPS.ECE_SSSO_ITEMS_V is not referenced by any database object