[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_MRP_OPEN_DEMANDS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ONT.OE_MRP_OPEN_DEMANDS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The view is based on OE_ORDER_LINES. It picks up the relevant columns required by the scheduler's workbench. It does not pass pick up externally sourced line or service lines, and any other lines which have been shipped.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_NUMBER | NUMBER | Yes | Order number | |
| LINE_ID | NUMBER | Yes | Order line unique identifier | |
| ORG_ID | NUMBER | Operating unit | ||
| HEADER_ID | NUMBER | Yes | Order header unique identifier | |
| LINE_NUMBER | NUMBER | Yes | Order line number | |
| SHIPMENT_NUMBER | NUMBER | Yes | Order line shipment number | |
| OPTION_NUMBER | NUMBER | Order line option number | ||
| ORDERED_ITEM | VARCHAR2 | (2000) | Ordered item name | |
| REQUEST_SHIP_DATE | VARCHAR2 | (9) | Requested ship date | |
| REQUEST_ARRIVAL_DATE | DATE | Requested arrival date | ||
| PROMISE_DATE | DATE | Date promised | ||
| SCHEDULE_SHIP_DATE | DATE | Scheduled ship date | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Scheduled arrival date | ||
| LATEST_ACCEPTABLE_DATE | DATE | Latest acceptable date | ||
| ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Unit of measure for ordered quantity | |
| ORDERED_QUANTITY | NUMBER | Ordered quantity | ||
| DELIVERY_LEAD_TIME | NUMBER | Delivery lead time | ||
| SHIP_FROM_ORG_ID | NUMBER | Shipping warehouse | ||
| SHIP_TO_ORG_ID | NUMBER | Ship to Organization Id | ||
| SOLD_TO_ORG_ID | NUMBER | Customer id to whom item is sold | ||
| PROJECT_ID | NUMBER | Project associated with this transaction | ||
| TASK_ID | NUMBER | Task associated with this transaction | ||
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item unique identifier | |
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method | |
| LINK_TO_LINE_ID | NUMBER | System-generated identifier of the line's immediate parent in a configuration | ||
| ITEM_TYPE_CODE | VARCHAR2 | (30) | Type of item | |
| ATO_LINE_ID | NUMBER | System-generated identifier of top model line in an ATO configuration | ||
| COMPONENT_NUMBER | NUMBER | System-generated Identifier of the included item within a model or a class | ||
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Indicates whether line is in a ship-complete configuration | |
| RE_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether user entered the warehouse or the system did | |
| TOP_MODEL_LINE_ID | NUMBER | System-generated identifier of top parent line in a configuration | ||
| ARRIVAL_SET_ID | NUMBER | Arrival set identifier | ||
| SHIP_SET_ID | NUMBER | Ship set identifier | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | Arrival set name | |
| SHIP_SET_NAME | VARCHAR2 | (30) | Ship set name | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight carrier for order line | |
| FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status for the line | |
| ORDER_DATE_TYPE_CODE | VARCHAR2 | (30) | Order Date Type Code (Ship or Arrival) | |
| OVERRIDE_ATP_DATE_CODE | VARCHAR2 | (30) | By setting this code, user can force a Schedule Ship Date , even if the supply is not available | |
| ORDER_TYPE_ID | NUMBER | Yes | Order type identifier | |
| ORDER_TYPE | VARCHAR2 | (30) | Yes | Order type name |
| PLANNING_PRIORITY | NUMBER | Planning priority | ||
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Yes | Line Category |
| EARLIEST_ACCEPTABLE_DATE | DATE | Earliest Acceptable Date |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_NUMBER
, LINE_ID
, ORG_ID
, HEADER_ID
, LINE_NUMBER
, SHIPMENT_NUMBER
, OPTION_NUMBER
, ORDERED_ITEM
, REQUEST_SHIP_DATE
, REQUEST_ARRIVAL_DATE
, PROMISE_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY
, DELIVERY_LEAD_TIME
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, SOLD_TO_ORG_ID
, PROJECT_ID
, TASK_ID
, INVENTORY_ITEM_ID
, DEMAND_CLASS_CODE
, SHIPPING_METHOD_CODE
, LINK_TO_LINE_ID
, ITEM_TYPE_CODE
, ATO_LINE_ID
, COMPONENT_NUMBER
, SHIP_MODEL_COMPLETE_FLAG
, RE_SOURCE_FLAG
, TOP_MODEL_LINE_ID
, ARRIVAL_SET_ID
, SHIP_SET_ID
, ARRIVAL_SET_NAME
, SHIP_SET_NAME
, FREIGHT_CARRIER_CODE
, FLOW_STATUS_CODE
, ORDER_DATE_TYPE_CODE
, OVERRIDE_ATP_DATE_CODE
, ORDER_TYPE_ID
, ORDER_TYPE
, PLANNING_PRIORITY
, LINE_CATEGORY_CODE
, EARLIEST_ACCEPTABLE_DATE
FROM APPS.OE_MRP_OPEN_DEMANDS_V;
APPS
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_SETS
OE_TRANSACTION_TYPES_VL
APPS
MSC_BAL_UTILS
- show dependent code
|
|
|
|