[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ORDERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  MSC.MSC_ORDERS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SOURCE_TABLE | VARCHAR2 | (12) | ||
| ROW_ID | ROWID | (10) | ||
| TRANSACTION_ID | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| LAST_UPDATE_LOGIN | NUMBER | |||
| INVENTORY_ITEM_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| ORGANIZATION_CODE | VARCHAR2 | (7) | ||
| PLAN_ORGANIZATION_ID | NUMBER | |||
| PLAN_INSTANCE_ID | NUMBER | |||
| SR_INSTANCE_ID | NUMBER | |||
| PLAN_ID | NUMBER | |||
| COMPILE_DESIGNATOR | VARCHAR2 | (10) | ||
| ACTION | VARCHAR2 | (4000) | ||
| NEW_DUE_DATE | DATE | |||
| OLD_DUE_DATE | DATE | |||
| NEW_START_DATE | DATE | |||
| DISPOSITION_ID | NUMBER | |||
| ORDER_NUMBER | VARCHAR2 | (4000) | ||
| DISPOSITION_STATUS_TYPE | NUMBER | |||
| ORDER_TYPE | NUMBER | |||
| ORDER_TYPE_TEXT | VARCHAR2 | (4000) | ||
| QUANTITY_RATE | NUMBER | |||
| OLD_ORDER_QUANTITY | NUMBER | |||
| NEW_ORDER_DATE | DATE | |||
| FIRM_PLANNED_TYPE | NUMBER | |||
| RESCHEDULED_FLAG | NUMBER | |||
| NEW_PROCESSING_DAYS | NUMBER | |||
| IMPLEMENTED_QUANTITY | NUMBER | |||
| LAST_UNIT_COMPLETION_DATE | DATE | |||
| FIRST_UNIT_START_DATE | DATE | |||
| LAST_UNIT_START_DATE | DATE | |||
| NEW_DOCK_DATE | DATE | |||
| QUANTITY_IN_PROCESS | NUMBER | |||
| FIRM_QUANTITY | NUMBER | |||
| FIRM_DATE | DATE | |||
| LINE_ID | NUMBER | |||
| LINE_CODE | VARCHAR2 | (4000) | ||
| IMPLEMENT_DEMAND_CLASS | VARCHAR2 | (30) | ||
| ITEM_SEGMENTS | VARCHAR2 | (250) | ||
| IMPLEMENT_DATE | DATE | |||
| IMPLEMENT_QUANTITY_RATE | NUMBER | |||
| IMPLEMENT_FIRM | NUMBER | |||
| IMPLEMENT_PROCESSING_DAYS | NUMBER | |||
| IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | (10) | ||
| IMPLEMENT_JOB_NAME | VARCHAR2 | (240) | ||
| IMPLEMENT_LINE_ID | NUMBER | |||
| IMPLEMENT_STATUS_CODE | NUMBER | |||
| IMPLEMENT_LOCATION_ID | NUMBER | |||
| RELEASE_STATUS | NUMBER | |||
| IMPLEMENT_AS | NUMBER | |||
| IMPLEMENT_AS_TEXT | VARCHAR2 | (4000) | ||
| PLANNER_CODE | VARCHAR2 | (10) | ||
| USING_ASSEMBLY_ITEM_ID | NUMBER | |||
| CATEGORY_ID | NUMBER | |||
| MRP_PLANNING_CODE | NUMBER | |||
| REPETITIVE_TYPE | NUMBER | |||
| BUILD_IN_WIP_FLAG | NUMBER | |||
| PURCHASING_ENABLED_FLAG | NUMBER | |||
| PLANNING_MAKE_BUY_CODE | NUMBER | |||
| DAYS_FROM_TODAY | NUMBER | |||
| BOM_ITEM_TYPE | NUMBER | |||
| BASE_ITEM_ID | NUMBER | |||
| WIP_SUPPLY_TYPE | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_SR_INSTANCE_ID | NUMBER | |||
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
| STATUS_CODE | NUMBER | |||
| USING_ASSEMBLY_SEGMENTS | VARCHAR2 | (4000) | ||
| FULL_PEGGING | NUMBER | |||
| SOURCE_VENDOR_ID | NUMBER | |||
| SOURCE_VENDOR_NAME | VARCHAR2 | (4000) | ||
| SOURCE_VENDOR_SITE_ID | NUMBER | |||
| SOURCE_VENDOR_SITE_CODE | VARCHAR2 | (4000) | ||
| VENDOR_ID | NUMBER | |||
| SUPPLIER_NAME | VARCHAR2 | (4000) | ||
| VENDOR_SITE_ID | NUMBER | |||
| SUPPLIER_SITE_CODE | VARCHAR2 | (4000) | ||
| IMPLEMENT_SOURCE_ORG_ID | NUMBER | |||
| IMPLEMENT_SR_INSTANCE_ID | NUMBER | |||
| IMPLEMENT_VENDOR_ID | NUMBER | |||
| IMPLEMENT_VENDOR_SITE_ID | NUMBER | |||
| IN_SOURCE_PLAN | NUMBER | |||
| SCHEDULE_COMPRESSION_DAYS | NUMBER | |||
| PROJECT_ID | NUMBER | (15) | ||
| TASK_ID | NUMBER | (15) | ||
| PROJECT_NUMBER | VARCHAR2 | (4000) | ||
| TASK_NUMBER | VARCHAR2 | (4000) | ||
| IMPLEMENT_PROJECT_ID | NUMBER | |||
| IMPLEMENT_TASK_ID | NUMBER | |||
| PLANNING_GROUP | VARCHAR2 | (30) | ||
| STATUS | NUMBER | |||
| APPLIED | NUMBER | |||
| RELEASE_TIME_FENCE_CODE | NUMBER | |||
| IMPLEMENT_SCHEDULE_GROUP_ID | NUMBER | |||
| IMPLEMENT_BUILD_SEQUENCE | NUMBER | |||
| BUILD_SEQUENCE | NUMBER | |||
| SCHEDULE_GROUP_ID | NUMBER | |||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (4000) | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (4000) | ||
| PROCESS_SEQ_ID | NUMBER | |||
| IMPLEMENT_ALTERNATE_BOM | VARCHAR2 | (10) | ||
| IMPLEMENT_ALTERNATE_ROUTING | VARCHAR2 | (10) | ||
| SCHEDULE_GROUP_NAME | VARCHAR2 | (30) | ||
| IMPLEMENT_EMPLOYEE_ID | NUMBER | |||
| CFM_ROUTING_FLAG | NUMBER | |||
| BUYER_NAME | VARCHAR2 | (240) | ||
| RELEASE_ERRORS | VARCHAR2 | (250) | ||
| REL_ALL_QTY | NUMBER | |||
| UNIT_NUMBER | VARCHAR2 | (30) | ||
| IMPLEMENT_UNIT_NUMBER | VARCHAR2 | (30) | ||
| DESCRIPTION | VARCHAR2 | (240) | ||
| PLANNING_GROUP_HIDDEN | VARCHAR2 | (30) | ||
| BUYER_NAME_HIDDEN | VARCHAR2 | (240) | ||
| PLANNER_CODE_HIDDEN | VARCHAR2 | (10) | ||
| PROJECT_ID_HIDDEN | NUMBER | |||
| TASK_ID_HIDDEN | NUMBER | |||
| LENDING_PROJECT_NUMBER | VARCHAR2 | (4000) | ||
| LENDING_TASK_NUMBER | VARCHAR2 | (4000) | ||
| CATEGORY_SET_ID | NUMBER | |||
| CATEGORY_NAME | VARCHAR2 | (250) | ||
| PRODUCT_FAMILY_ID | NUMBER | |||
| PRODUCT_FAMILY_NAME | VARCHAR2 | (4000) | ||
| BASE_ITEM_NAME | VARCHAR2 | (4000) | ||
| ABC_CLASS | VARCHAR2 | (40) | ||
| UOM_CODE | VARCHAR2 | (3) | ||
| INTERNAL_SO_NUMBER | VARCHAR2 | (4000) | ||
| DEMAND_PRIORITY | NUMBER | |||
| PROMISE_DATE | DATE | |||
| REQUEST_DATE | DATE | |||
| CUSTOMER_ID | NUMBER | |||
| CUSTOMER_NAME | VARCHAR2 | (4000) | ||
| CUSTOMER_SITE_ID | NUMBER | |||
| CUSTOMER_SITE_NAME | VARCHAR2 | (4000) | ||
| SHIP_TO_SITE_ID | NUMBER | |||
| SHIP_TO_SITE_NAME | VARCHAR2 | (4000) | ||
| LOT_NUMBER | VARCHAR2 | (80) | ||
| SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
| PARENT_ID | NUMBER | |||
| WIP_STATUS_CODE | NUMBER | |||
| WIP_STATUS_TEXT | VARCHAR2 | (4000) | ||
| DMD_LATENESS_COST | NUMBER | |||
| DMD_SATISFIED_DATE | DATE | |||
| NEED_BY_DATE | DATE | |||
| DESIGNATOR_NAME | VARCHAR2 | (4000) | ||
| LIST_PRICE | NUMBER | |||
| STANDARD_COST | NUMBER | |||
| SELLING_PRICE | NUMBER | |||
| SERVICE_LEVEL | NUMBER | |||
| DEMAND_CLASS | VARCHAR2 | (34) | ||
| PROBABILITY | NUMBER | |||
| SHIP_DATE | DATE | |||
| QUANTITY | NUMBER | |||
| ASSEMBLY_DEMAND_COMP_DATE | DATE | |||
| BUCKET_TYPE | VARCHAR2 | (7) | ||
| SOURCE_DMD_PRIORITY | NUMBER | |||
| PO_LINE_ID | NUMBER | |||
| RESCHEDULE_DAYS | NUMBER | |||
| OLD_NEED_BY_DATE | DATE | |||
| CUMULATIVE_PROBABILITY | NUMBER | |||
| ORIGINAL_ITEM_ID | NUMBER | |||
| ORIGINAL_ITEM_NAME | VARCHAR2 | (4000) | ||
| ORIGINAL_ITEM_QTY | NUMBER | |||
| SHIP_METHOD | VARCHAR2 | (30) | ||
| EXPLOSION_DATE | DATE | |||
| UNMET_QUANTITY | NUMBER | |||
| ORIGINAL_QUANTITY | NUMBER | |||
| ORIGINAL_NEED_BY_DATE | DATE | |||
| EPST | DATE | |||
| EPCT | DATE | |||
| MIN_START_TIME | DATE | |||
| LOW_LEVEL_CODE | NUMBER | |||
| ORDERS_DAYS_LATE | NUMBER | |||
| ULPSD | DATE | |||
| ULPCD | DATE | |||
| UEPSD | DATE | |||
| UEPCD | DATE | |||
| EACD | DATE | |||
| SUPPLY_IS_SHARED | NUMBER | |||
| RECORD_SOURCE | NUMBER | |||
| FORWARD_DAYS | NUMBER | |||
| BACKWARD_DAYS | NUMBER | |||
| WIP_START_QUANTITY | NUMBER | |||
| EXPIRATION_DATE | DATE | |||
| MRP_PLANNING_CODE_TEXT | VARCHAR2 | (4000) | ||
| ORIGINAL_ORG_ID | NUMBER | |||
| ORIGINAL_INST_ID | NUMBER | |||
| START_QUANTITY | NUMBER | |||
| CRITICAL_COMPONENT_FLAG | NUMBER | |||
| ORDER_DATE_TYPE_CODE | NUMBER | |||
| ORDER_DATE_TYPE_TEXT | VARCHAR2 | (4000) | ||
| SCHEDULE_ARRIVAL_DATE | DATE | |||
| LATEST_ACCEPTABLE_DATE | DATE | |||
| PLANNED_ARRIVAL_DATE | DATE | |||
| SHIPMENT_ID | NUMBER | |||
| SHIP_CALENDAR | VARCHAR2 | (15) | ||
| RECEIVING_CALENDAR | VARCHAR2 | (15) | ||
| INTRANSIT_CALENDAR | VARCHAR2 | (15) | ||
| INTRANSIT_LEAD_TIME | NUMBER | |||
| IMPLEMENT_DOCK_DATE | DATE | |||
| IMPLEMENT_SHIP_DATE | DATE | |||
| IMPLEMENT_ARRIVAL_DATE | DATE | |||
| REQUEST_SHIP_DATE | DATE | |||
| PROMISE_SHIP_DATE | DATE | |||
| LATE_DAYS | NUMBER | To indicate days late of supply and demand | ||
| RECOMMENDED | VARCHAR2 | (0) | ||
| SUBSTITUTE_COMPONENT_RANK | NUMBER | |||
| COMPONENT_YIELD | NUMBER | |||
| SOURCE_TABLE2 | VARCHAR2 | (12) | ||
| VMI_FLAG | NUMBER | |||
| WEIGHT | NUMBER | |||
| VOLUME | NUMBER | |||
| SCHEDULE_SHIP_DATE | DATE | |||
| DEST_ORG_CODE | VARCHAR2 | (4000) | ||
| QTY_BY_DUE_DATE | NUMBER | |||
| SHIP_SET_NAME | VARCHAR2 | (30) | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | ||
| ORIG_ORG_CODE | VARCHAR2 | (4000) | ||
| ORIG_LEAD_TIME | NUMBER | |||
| ORIG_SHIP_METHOD | VARCHAR2 | (30) | ||
| DEST_ORG_ID | NUMBER | |||
| DEST_INST_ID | NUMBER | |||
| IMPLEMENT_DEST_ORG_ID | NUMBER | |||
| IMPLEMENT_DEST_INST_ID | NUMBER | |||
| IMPLEMENT_DEST_ORG_CODE | VARCHAR2 | (0) | ||
| HIDDEN_DOCK_DATE | DATE | |||
| FINAL_USE_PRIORITY | NUMBER | |||
| FINAL_USE_DATE | DATE | |||
| ZONE | VARCHAR2 | (4000) | ||
| ALLOCATION_QTY | NUMBER | |||
| FIRM_ALLOCATION_FLAG | NUMBER | |||
| ALLOCATION_DATE | DATE | |||
| SALES_ORDER_LINE_SPLIT | VARCHAR2 | (4000) | ||
| PARENT_WORK_ORDER | NUMBER | EAM Parent work order of a child work order | ||
| ASSET_GROUP | VARCHAR2 | (4000) | Asset Item Description | |
| ASSET_NUMBER | VARCHAR2 | (30) | Asset number or rebuild serial number | |
| REQUESTED_START_DATE | DATE | Requested start date of the WO | ||
| REQUESTED_COMPLETION_DATE | DATE | Requested completion/Due date of the WO | ||
| FILL_KILL_FLAG | NUMBER | |||
| LOTS_EXIST | NUMBER | |||
| IMPLEMENT_SHIP_METHOD | VARCHAR2 | (30) | ||
| ACTUAL_START_DATE | DATE | |||
| FIRM_DUE_DATE | DATE | |||
| IMPLEMENT_DUE_DATE | DATE | |||
| HIDDEN_DUE_DATE | DATE | |||
| WITHIN_REL_TIME_FENCE | NUMBER | Flag to indicate whether an item order is with in the release time fence or not. 1 - Yes, 2 - No | ||
| AMOUNT | NUMBER | Cost of an Order Line. | ||
| SO_LINE_SPLIT | NUMBER | |||
| FORECAST_SET_ID | NUMBER | |||
| SCHEDULE_DESIGNATOR_ID | NUMBER | |||
| DELIVERY_PRICE | NUMBER | |||
| SALES_ORDER_LINE_ID | NUMBER | Sales Order Line ID | ||
| SHIP_SET_ID | NUMBER | Ship Set ID | ||
| ARRIVAL_SET_ID | NUMBER | Arrival Set ID | ||
| ITEM_TYPE_ID | NUMBER | |||
| ITEM_TYPE_VALUE | NUMBER | |||
| PART_CONDITION | VARCHAR2 | (4000) | ||
| FIRM_START_DATE | DATE | |||
| BILL_SEQUENCE_ID | NUMBER | |||
| ROUTING_SEQUENCE_ID | NUMBER | |||
| PREV_SUBST_ITEM_ID | NUMBER | |||
| PREV_SUBST_ORG_ID | NUMBER | |||
| PREV_SUBST_ITEM | VARCHAR2 | (4000) | ||
| PREV_SUBST_ORG | VARCHAR2 | (4000) | ||
| OTM_ARRIVAL_DATE | DATE | Updated arrival date received from OTM. | ||
| MIN_REM_SHELF_LIFE_DAYS | NUMBER | |||
| COMMENTS | VARCHAR2 | (4000) | ||
| SUGGESTED_PICK_DATE | DATE | |||
| PICK_PACK_LT | NUMBER | |||
| CUSTOMER_PO_NUMBER | VARCHAR2 | (4000) | ||
| CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | (4000) | ||
| MAPE_IN_SAMPLE | NUMBER | Mean absolute Percentage Error | ||
| MAPE_OUT_SAMPLE | NUMBER | Forecast to Actuals Deviation Percentage | ||
| FORECAST_VOLATILITY | NUMBER | Forecast Volatility Percentage | ||
| AVG_DEMAND | NUMBER | Average Demand Qty | ||
| QTY_EXCESS_OF_EOQ | NUMBER | Quantity in Excess of EOQ | ||
| QTY_EXCESS_OF_EOQ_PCT | NUMBER | Percentage excess over EOQ | ||
| QTY_EXCESS_OF_AVG_DEMAND | NUMBER | Quantity in excess of Average Demand | ||
| QTY_EXCESS_OF_AVG_DEMAND_PCT | NUMBER | Percentage excess over Average Demand | ||
| PRODUCT_CLASSIFICATION | VARCHAR2 | (150) | ||
| MAINTENANCE_REQT | VARCHAR2 | (80) | ||
| PRODUCES_TO_STOCK | VARCHAR2 | (4000) | ||
| VISIT_ID | NUMBER | |||
| VISIT_NAME | VARCHAR2 | (4000) | ||
| ACTIVITY_TYPE | VARCHAR2 | (4000) | ||
| ACTIVITY_NAME | VARCHAR2 | (4000) | ||
| CLASS_CODE | VARCHAR2 | (10) | ||
| SHUTDOWN_TYPE | NUMBER | |||
| MAINTENANCE_PLAN | VARCHAR2 | (4000) | ||
| ACTIVITY_ITEM_ID | NUMBER | |||
| TOP_MODEL_ITEM_NAME | VARCHAR2 | (4000) | ||
| PARENT_MODEL_ITEM_NAME | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_TABLE
, ROW_ID
, TRANSACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, PLAN_ORGANIZATION_ID
, PLAN_INSTANCE_ID
, SR_INSTANCE_ID
, PLAN_ID
, COMPILE_DESIGNATOR
, ACTION
, NEW_DUE_DATE
, OLD_DUE_DATE
, NEW_START_DATE
, DISPOSITION_ID
, ORDER_NUMBER
, DISPOSITION_STATUS_TYPE
, ORDER_TYPE
, ORDER_TYPE_TEXT
, QUANTITY_RATE
, OLD_ORDER_QUANTITY
, NEW_ORDER_DATE
, FIRM_PLANNED_TYPE
, RESCHEDULED_FLAG
, NEW_PROCESSING_DAYS
, IMPLEMENTED_QUANTITY
, LAST_UNIT_COMPLETION_DATE
, FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE
, NEW_DOCK_DATE
, QUANTITY_IN_PROCESS
, FIRM_QUANTITY
, FIRM_DATE
, LINE_ID
, LINE_CODE
, IMPLEMENT_DEMAND_CLASS
, ITEM_SEGMENTS
, IMPLEMENT_DATE
, IMPLEMENT_QUANTITY_RATE
, IMPLEMENT_FIRM
, IMPLEMENT_PROCESSING_DAYS
, IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_JOB_NAME
, IMPLEMENT_LINE_ID
, IMPLEMENT_STATUS_CODE
, IMPLEMENT_LOCATION_ID
, RELEASE_STATUS
, IMPLEMENT_AS
, IMPLEMENT_AS_TEXT
, PLANNER_CODE
, USING_ASSEMBLY_ITEM_ID
, CATEGORY_ID
, MRP_PLANNING_CODE
, REPETITIVE_TYPE
, BUILD_IN_WIP_FLAG
, PURCHASING_ENABLED_FLAG
, PLANNING_MAKE_BUY_CODE
, DAYS_FROM_TODAY
, BOM_ITEM_TYPE
, BASE_ITEM_ID
, WIP_SUPPLY_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_SR_INSTANCE_ID
, SOURCE_ORGANIZATION_CODE
, STATUS_CODE
, USING_ASSEMBLY_SEGMENTS
, FULL_PEGGING
, SOURCE_VENDOR_ID
, SOURCE_VENDOR_NAME
, SOURCE_VENDOR_SITE_ID
, SOURCE_VENDOR_SITE_CODE
, VENDOR_ID
, SUPPLIER_NAME
, VENDOR_SITE_ID
, SUPPLIER_SITE_CODE
, IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_SR_INSTANCE_ID
, IMPLEMENT_VENDOR_ID
, IMPLEMENT_VENDOR_SITE_ID
, IN_SOURCE_PLAN
, SCHEDULE_COMPRESSION_DAYS
, PROJECT_ID
, TASK_ID
, PROJECT_NUMBER
, TASK_NUMBER
, IMPLEMENT_PROJECT_ID
, IMPLEMENT_TASK_ID
, PLANNING_GROUP
, STATUS
, APPLIED
, RELEASE_TIME_FENCE_CODE
, IMPLEMENT_SCHEDULE_GROUP_ID
, IMPLEMENT_BUILD_SEQUENCE
, BUILD_SEQUENCE
, SCHEDULE_GROUP_ID
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, PROCESS_SEQ_ID
, IMPLEMENT_ALTERNATE_BOM
, IMPLEMENT_ALTERNATE_ROUTING
, SCHEDULE_GROUP_NAME
, IMPLEMENT_EMPLOYEE_ID
, CFM_ROUTING_FLAG
, BUYER_NAME
, RELEASE_ERRORS
, REL_ALL_QTY
, UNIT_NUMBER
, IMPLEMENT_UNIT_NUMBER
, DESCRIPTION
, PLANNING_GROUP_HIDDEN
, BUYER_NAME_HIDDEN
, PLANNER_CODE_HIDDEN
, PROJECT_ID_HIDDEN
, TASK_ID_HIDDEN
, LENDING_PROJECT_NUMBER
, LENDING_TASK_NUMBER
, CATEGORY_SET_ID
, CATEGORY_NAME
, PRODUCT_FAMILY_ID
, PRODUCT_FAMILY_NAME
, BASE_ITEM_NAME
, ABC_CLASS
, UOM_CODE
, INTERNAL_SO_NUMBER
, DEMAND_PRIORITY
, PROMISE_DATE
, REQUEST_DATE
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_SITE_ID
, CUSTOMER_SITE_NAME
, SHIP_TO_SITE_ID
, SHIP_TO_SITE_NAME
, LOT_NUMBER
, SUBINVENTORY_CODE
, PARENT_ID
, WIP_STATUS_CODE
, WIP_STATUS_TEXT
, DMD_LATENESS_COST
, DMD_SATISFIED_DATE
, NEED_BY_DATE
, DESIGNATOR_NAME
, LIST_PRICE
, STANDARD_COST
, SELLING_PRICE
, SERVICE_LEVEL
, DEMAND_CLASS
, PROBABILITY
, SHIP_DATE
, QUANTITY
, ASSEMBLY_DEMAND_COMP_DATE
, BUCKET_TYPE
, SOURCE_DMD_PRIORITY
, PO_LINE_ID
, RESCHEDULE_DAYS
, OLD_NEED_BY_DATE
, CUMULATIVE_PROBABILITY
, ORIGINAL_ITEM_ID
, ORIGINAL_ITEM_NAME
, ORIGINAL_ITEM_QTY
, SHIP_METHOD
, EXPLOSION_DATE
, UNMET_QUANTITY
, ORIGINAL_QUANTITY
, ORIGINAL_NEED_BY_DATE
, EPST
, EPCT
, MIN_START_TIME
, LOW_LEVEL_CODE
, ORDERS_DAYS_LATE
, ULPSD
, ULPCD
, UEPSD
, UEPCD
, EACD
, SUPPLY_IS_SHARED
, RECORD_SOURCE
, FORWARD_DAYS
, BACKWARD_DAYS
, WIP_START_QUANTITY
, EXPIRATION_DATE
, MRP_PLANNING_CODE_TEXT
, ORIGINAL_ORG_ID
, ORIGINAL_INST_ID
, START_QUANTITY
, CRITICAL_COMPONENT_FLAG
, ORDER_DATE_TYPE_CODE
, ORDER_DATE_TYPE_TEXT
, SCHEDULE_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE
, PLANNED_ARRIVAL_DATE
, SHIPMENT_ID
, SHIP_CALENDAR
, RECEIVING_CALENDAR
, INTRANSIT_CALENDAR
, INTRANSIT_LEAD_TIME
, IMPLEMENT_DOCK_DATE
, IMPLEMENT_SHIP_DATE
, IMPLEMENT_ARRIVAL_DATE
, REQUEST_SHIP_DATE
, PROMISE_SHIP_DATE
, LATE_DAYS
, RECOMMENDED
, SUBSTITUTE_COMPONENT_RANK
, COMPONENT_YIELD
, SOURCE_TABLE2
, VMI_FLAG
, WEIGHT
, VOLUME
, SCHEDULE_SHIP_DATE
, DEST_ORG_CODE
, QTY_BY_DUE_DATE
, SHIP_SET_NAME
, ARRIVAL_SET_NAME
, ORIG_ORG_CODE
, ORIG_LEAD_TIME
, ORIG_SHIP_METHOD
, DEST_ORG_ID
, DEST_INST_ID
, IMPLEMENT_DEST_ORG_ID
, IMPLEMENT_DEST_INST_ID
, IMPLEMENT_DEST_ORG_CODE
, HIDDEN_DOCK_DATE
, FINAL_USE_PRIORITY
, FINAL_USE_DATE
, ZONE
, ALLOCATION_QTY
, FIRM_ALLOCATION_FLAG
, ALLOCATION_DATE
, SALES_ORDER_LINE_SPLIT
, PARENT_WORK_ORDER
, ASSET_GROUP
, ASSET_NUMBER
, REQUESTED_START_DATE
, REQUESTED_COMPLETION_DATE
, FILL_KILL_FLAG
, LOTS_EXIST
, IMPLEMENT_SHIP_METHOD
, ACTUAL_START_DATE
, FIRM_DUE_DATE
, IMPLEMENT_DUE_DATE
, HIDDEN_DUE_DATE
, WITHIN_REL_TIME_FENCE
, AMOUNT
, SO_LINE_SPLIT
, FORECAST_SET_ID
, SCHEDULE_DESIGNATOR_ID
, DELIVERY_PRICE
, SALES_ORDER_LINE_ID
, SHIP_SET_ID
, ARRIVAL_SET_ID
, ITEM_TYPE_ID
, ITEM_TYPE_VALUE
, PART_CONDITION
, FIRM_START_DATE
, BILL_SEQUENCE_ID
, ROUTING_SEQUENCE_ID
, PREV_SUBST_ITEM_ID
, PREV_SUBST_ORG_ID
, PREV_SUBST_ITEM
, PREV_SUBST_ORG
, OTM_ARRIVAL_DATE
, MIN_REM_SHELF_LIFE_DAYS
, COMMENTS
, SUGGESTED_PICK_DATE
, PICK_PACK_LT
, CUSTOMER_PO_NUMBER
, CUSTOMER_PO_LINE_NUMBER
, MAPE_IN_SAMPLE
, MAPE_OUT_SAMPLE
, FORECAST_VOLATILITY
, AVG_DEMAND
, QTY_EXCESS_OF_EOQ
, QTY_EXCESS_OF_EOQ_PCT
, QTY_EXCESS_OF_AVG_DEMAND
, QTY_EXCESS_OF_AVG_DEMAND_PCT
, PRODUCT_CLASSIFICATION
, MAINTENANCE_REQT
, PRODUCES_TO_STOCK
, VISIT_ID
, VISIT_NAME
, ACTIVITY_TYPE
, ACTIVITY_NAME
, CLASS_CODE
, SHUTDOWN_TYPE
, MAINTENANCE_PLAN
, ACTIVITY_ITEM_ID
, TOP_MODEL_ITEM_NAME
, PARENT_MODEL_ITEM_NAME
FROM APPS.MSC_ORDERS_V;
APPS
MFG_LOOKUPS
MSC_DEMANDS
MSC_DMD_SCN_METRICS
MSC_DRP_UTIL
- show dependent code
MSC_GET_NAME
- show dependent code
MSC_ITEM_CATEGORIES
MSC_PLANS
MSC_PROCESS_EFFECTIVITY
MSC_REL_PLAN_PUB
- show dependent code
MSC_SUPPLIES
MSC_SYSTEM_ITEMS
MSC_UTIL
- show dependent code
APPS
MSC_DS_SCHEDULE
- show dependent code
MSC_PQ_UTILS
- show dependent code
|
|
|
|