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

VIEW: APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V

Object Details
Object Name: MSC_SUP_DEM_ENT_CUSTOM_EX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_SUP_DEM_ENT_CUSTOM_EX_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V references the following:

SchemaAPPS
SynonymMSC_SUP_DEM_ENTRIES
PL/SQL PackageMSC_X_UDE_PEGGING - show dependent code

APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V is not referenced by any database object