[Home] [Help] [Dependency Information]
Object Name: | MSC_SUP_DEM_ENT_CUSTOM_EX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_SUP_DEM_ENT_CUSTOM_EX_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
PLAN_ID | NUMBER | Yes | Plan identifier | |
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
PUBLISHER_ID | NUMBER | Yes | Publisher identifier | |
PUBLISHER_SITE_ID | NUMBER | Yes | Publisher site identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
SUPPLIER_ID | NUMBER | Supplier identifier | ||
CUSTOMER_ID | NUMBER | Customer identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer site identifier | ||
LAST_REFRESH_NUMBER | NUMBER | Last refresh number | ||
DAYS_LATE | NUMBER | Calculated Column: Days Late | ||
DAYS_EARLY | NUMBER | Calculated Column: Days Early | ||
QUANTITY_EXCESS | NUMBER | Calculated Column: Quantity Excess | ||
QUANTITY_SHORTAGE | NUMBER | Calculated Column: Quantity Shortage | ||
AVERAGE_ANNUAL_DEMAND | NUMBER | Average annual demand | ||
BASE_ITEM_NAME | VARCHAR2 | (250) | Base Item Name | |
BILL_OF_LADING_NUMBER | VARCHAR2 | (30) | Bill of lading number | |
BUCKET_TYPE_DESC | VARCHAR2 | (30) | Bucket type description | |
CARRIER_CODE | VARCHAR2 | (30) | Carrier code | |
CATEGORY_NAME | VARCHAR2 | (200) | Category name | |
CONTAINER_QTY | NUMBER | Container quantity | ||
CONTAINER_TYPE | VARCHAR2 | (20) | Container type | |
CUSTOMER_ITEM_NAME | VARCHAR2 | (250) | Customer item name | |
CUSTOMER_NAME | VARCHAR2 | (255) | Customer name | |
CUSTOMER_SITE_NAME | VARCHAR2 | (40) | Customer site name | |
DESIGNATOR | VARCHAR2 | (100) | Designator | |
END_ORDER_LINE_NUMBER | VARCHAR2 | (25) | Pegged order line number | |
END_ORDER_NUMBER | VARCHAR2 | (240) | Pegged order number | |
END_ORDER_PUBLISHER_NAME | VARCHAR2 | (255) | End order publisher name | |
END_ORDER_PUBLISHER_SITE_NAME | VARCHAR2 | (40) | End order publisher site name | |
END_ORDER_REL_NUMBER | VARCHAR2 | (25) | Pegged order release number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
ITEM_NAME | VARCHAR2 | (250) | Item name | |
LINE_NUMBER | VARCHAR2 | (25) | Line number | |
NEED_BY_DATE | DATE | Need By Date | ||
NEW_ORDER_PLACEMENT_DATE | DATE | New order placement date | ||
NEW_SCHEDULE_DATE | DATE | New schedule date | ||
ORDER_NUMBER | VARCHAR2 | (240) | Order number | |
OWNER_ITEM_NAME | VARCHAR2 | (250) | Owner item name | |
PLANNER_CODE | VARCHAR2 | (10) | Planner code | |
PLANNING_GROUP | VARCHAR2 | (30) | Planning group | |
POSTING_PARTY_NAME | VARCHAR2 | (255) | Posting party name | |
PROJECT_NUMBER | VARCHAR2 | (30) | Project number | |
PROMISED_DATE | DATE | Promised Date | ||
PUBLISHER_NAME | VARCHAR2 | (255) | Publisher Name | |
PUBLISHER_ORDER_TYPE | NUMBER | Yes | Publisher order type | |
PUBLISHER_ORDER_TYPE_DESC | VARCHAR2 | (80) | Publisher order type description | |
PUBLISHER_SITE_NAME | VARCHAR2 | (40) | Publisher Site Name | |
QUANTITY | NUMBER | Yes | Quantity | |
RECEIPT_DATE | DATE | Receipt date | ||
RELEASE_NUMBER | VARCHAR2 | (25) | Release number | |
RELEASE_STATUS | NUMBER | Release status | ||
REQUEST_DATE | DATE | Request date | ||
SHIPPING_CONTROL | VARCHAR2 | (30) | Shipping Control | |
SHIP_DATE | DATE | Ship date | ||
SHIP_FROM_PARTY_NAME | VARCHAR2 | (255) | Ship from party name | |
SHIP_FROM_PARTY_SITE_NAME | VARCHAR2 | (40) | Ship from party site name | |
SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
SHIP_TO_PARTY_NAME | VARCHAR2 | (255) | Ship to party name | |
SHIP_TO_PARTY_SITE_NAME | VARCHAR2 | (40) | Ship to party site name | |
SUPPLIER_ITEM_NAME | VARCHAR2 | (250) | Supplier item name | |
SUPPLIER_NAME | VARCHAR2 | (255) | Supplier name | |
SUPPLIER_SITE_NAME | VARCHAR2 | (40) | Supplier site name | |
TASK_NUMBER | VARCHAR2 | (30) | Task number | |
TRACKING_NUMBER | VARCHAR2 | (240) | Tracking number | |
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
VEHICLE_NUMBER | VARCHAR2 | (30) | Vehicle number | |
VERSION | VARCHAR2 | (240) | Version | |
WIP_END_DATE | DATE | WIP end date | ||
WIP_START_DATE | DATE | WIP start date | ||
CREATION_DATE | DATE | Yes | Creation Date |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, PLAN_ID
, SR_INSTANCE_ID
, PUBLISHER_ID
, PUBLISHER_SITE_ID
, INVENTORY_ITEM_ID
, SUPPLIER_ID
, CUSTOMER_ID
, SUPPLIER_SITE_ID
, CUSTOMER_SITE_ID
, LAST_REFRESH_NUMBER
, DAYS_LATE
, DAYS_EARLY
, QUANTITY_EXCESS
, QUANTITY_SHORTAGE
, AVERAGE_ANNUAL_DEMAND
, BASE_ITEM_NAME
, BILL_OF_LADING_NUMBER
, BUCKET_TYPE_DESC
, CARRIER_CODE
, CATEGORY_NAME
, CONTAINER_QTY
, CONTAINER_TYPE
, CUSTOMER_ITEM_NAME
, CUSTOMER_NAME
, CUSTOMER_SITE_NAME
, DESIGNATOR
, END_ORDER_LINE_NUMBER
, END_ORDER_NUMBER
, END_ORDER_PUBLISHER_NAME
, END_ORDER_PUBLISHER_SITE_NAME
, END_ORDER_REL_NUMBER
, ITEM_DESCRIPTION
, ITEM_NAME
, LINE_NUMBER
, NEED_BY_DATE
, NEW_ORDER_PLACEMENT_DATE
, NEW_SCHEDULE_DATE
, ORDER_NUMBER
, OWNER_ITEM_NAME
, PLANNER_CODE
, PLANNING_GROUP
, POSTING_PARTY_NAME
, PROJECT_NUMBER
, PROMISED_DATE
, PUBLISHER_NAME
, PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC
, PUBLISHER_SITE_NAME
, QUANTITY
, RECEIPT_DATE
, RELEASE_NUMBER
, RELEASE_STATUS
, REQUEST_DATE
, SHIPPING_CONTROL
, SHIP_DATE
, SHIP_FROM_PARTY_NAME
, SHIP_FROM_PARTY_SITE_NAME
, SHIP_METHOD
, SHIP_TO_PARTY_NAME
, SHIP_TO_PARTY_SITE_NAME
, SUPPLIER_ITEM_NAME
, SUPPLIER_NAME
, SUPPLIER_SITE_NAME
, TASK_NUMBER
, TRACKING_NUMBER
, UOM_CODE
, VEHICLE_NUMBER
, VERSION
, WIP_END_DATE
, WIP_START_DATE
, CREATION_DATE
FROM APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V;
APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V is not referenced by any database object
|
|
|