[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_SSSO_ITEMS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EC.ECE_SSSO_ITEMS_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
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;
APPS
CHV_CUM_PERIODS
CHV_ITEM_ORDERS
CHV_ORG_OPTIONS
CHV_SCHEDULE_HEADERS
CHV_SCHEDULE_ITEMS
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_LOCATIONS
HR_SECURITY
- show dependent code
MTL_ITEM_FLEXFIELDS
MTL_PARAMETERS
MTL_UNITS_OF_MEASURE
PER_ALL_PEOPLE_F
PER_PHONES
PO_HAZARD_CLASSES_B
PO_HAZARD_CLASSES_TL
PO_HEADERS
PO_LINES
PO_UN_NUMBERS_B
PO_UN_NUMBERS_TL
APPS.ECE_SSSO_ITEMS_V is not referenced by any database object
|
|
|
|