[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_ORDERS_V

Object Details

Object Name:	MSC_ORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_ORDERS_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

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