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

VIEW: APPS.MSC_EXCEPTION_DETAILS_V

Object Details
Object Name: MSC_EXCEPTION_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_EXCEPTION_DETAILS_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
EXCEPTION_ID NUMBER
Yes
SOURCE_TYPE NUMBER

PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

EXCEPTION_TYPE NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

ORGANIZATION_CODE VARCHAR2 (4000)
CATEGORY_SET_ID NUMBER

CATEGORY_ID NUMBER

CATEGORY_NAME VARCHAR2 (4000)
ITEM_SEGMENTS VARCHAR2 (4000)
ITEM_DESCRIPTION VARCHAR2 (4000)
BUYER_NAME VARCHAR2 (240)
PLANNER_CODE VARCHAR2 (10)
EXCEPTION_TYPE_TEXT VARCHAR2 (4000)
PROJECT_ID NUMBER

TASK_ID NUMBER

PLANNING_GROUP_HIDDEN VARCHAR2 (80)
PROJECT_NUMBER VARCHAR2 (4000)
TASK_NUMBER VARCHAR2 (4000)
PLANNING_GROUP VARCHAR2 (80)
TO_PROJECT_NUMBER VARCHAR2 (4000)
TO_TASK_NUMBER VARCHAR2 (4000)
DUE_DATE DATE

FROM_DATE DATE

TO_DATE DATE

DAYS_COMPRESSED NUMBER

QUANTITY NUMBER

LOT_NUMBER VARCHAR2 (80)
ORDER_NUMBER VARCHAR2 (4000)
SUPPLY_TYPE VARCHAR2 (0)
END_ITEM_SEGMENTS VARCHAR2 (4000)
PLANNED_INVENTORY_POINT VARCHAR2 (4000)
END_ORDER_NUMBER VARCHAR2 (4000)
TRANSACTION_ID NUMBER

DEMAND_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_ID NUMBER

DEPARTMENT_LINE_CODE VARCHAR2 (4000)
RESOURCE_CODE VARCHAR2 (4000)
RESOURCE_TYPE NUMBER

RESOURCE_TYPE_CODE VARCHAR2 (4000)
UTILIZATION_RATE NUMBER

SUPPLIER_ID VARCHAR2 (40)
SUPPLIER_NAME VARCHAR2 (4000)
SUPPLIER_SITE_ID VARCHAR2 (40)
SUPPLIER_SITE VARCHAR2 (4000)
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
CUSTOMER_SITE_ID NUMBER

CUSTOMER_SITE VARCHAR2 (4000)
ORDER_PRIORITY NUMBER

DMD_SATISFIED_DATE DATE

SUBSTITUTE_COMPONENT VARCHAR2 (4000)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (4000)
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (4000)
SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

SOURCE_ORGANIZATION_CODE VARCHAR2 (4000)
REPLENISHMENT_DATE DATE

END_PEGGING_ID NUMBER

DEMAND_QUANTITY NUMBER

OLD_DUE_DATE DATE

ORDER_TYPE VARCHAR2 (4000)
ORDER_TYPE_ID NUMBER

BATCHABLE_FLAG NUMBER

MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

BATCH_NUMBER NUMBER

REQUIRED_CAPACITY NUMBER

QUANTITY_BY_DUE_DATE NUMBER

RESOURCE_OVER_UTIL_COST NUMBER

ALLOCATED_PERCENTAGE NUMBER

ACTUAL_PERCENTAGE NUMBER

PERCENT_VARIANCE NUMBER

ACTION_TAKEN NUMBER

ROW_ID ROWID (10)
DAYS_LATE NUMBER

SUBSTITUTE_ITEM_ID NUMBER

SUBSTITUTE_ITEM_NAME VARCHAR2 (4000)
SUBSTITUTE_ORG_ID NUMBER

SUBSTITUTE_ORG_CODE VARCHAR2 (4000)
SUBSTITUTE_QTY NUMBER

PREFERENCE NUMBER

ORIGINATION_TYPE_ID NUMBER

ORIGINATION_TYPE VARCHAR2 (4000)
DEMAND_DATE_QUANTITY NUMBER

DEMAND_CLASS VARCHAR2 (34)
OPERATION_SEQ_NUM NUMBER

RESOURCE_SEQ_NUM NUMBER

FIRM_TYPE VARCHAR2 (4000)
FIRM_PLANNED_TYPE NUMBER

MIN_START_TIME DATE

MIN_LEAD_TIME NUMBER

NEW_DOCK_DATE DATE

AVAILABLE_CAPACITY NUMBER

QTY_MISMATCH NUMBER

ACTUAL_DURATION NUMBER

SUPPLY_ORGANIZATION_CODE VARCHAR2 (4000)
SUPPLY_ORGANIZATION_ID NUMBER

SUPPLY_SR_INSTANCE_ID NUMBER

SUPPLY_ITEM_SEGMENTS VARCHAR2 (4000)
SUPPLY_INVENTORY_ITEM_ID NUMBER

SUPPLY_PLANNER_CODE VARCHAR2 (4000)
SUPPLY_ORDER_TYPE VARCHAR2 (4000)
SUPPLY_ORDER_TYPE_ID NUMBER

SUPPLY_SUPPLIER_ID NUMBER

SUPPLY_SUPPLIER_NAME VARCHAR2 (4000)
SUPPLY_SUPPLIER_SITE_ID NUMBER

SUPPLY_SUPPLIER_SITE VARCHAR2 (4000)
SUPPLY_SOURCE_ORG_CODE VARCHAR2 (4000)
SUPPLY_SOURCE_ORG_ID NUMBER

SUPPLY_SOURCE_SR_INSTANCE_ID NUMBER

SUPPLY_PLANNING_GROUP VARCHAR2 (30)
SUPPLY_PROJECT_ID NUMBER (15)
SUPPLY_PROJECT_NUMBER VARCHAR2 (4000)
SUPPLY_TASK_ID NUMBER (15)
SUPPLY_TASK_NUMBER VARCHAR2 (4000)
SALES_ORDER_LINE_PRICE NUMBER

DUE_DATE_QTY_PCT NUMBER

COMPRESSION_PCT NUMBER

CONSTRAINT_PCT NUMBER

DAYS_EARLY_BEFORE_LADATE NUMBER

DAYS_EARLY_ARRIVAL NUMBER

DAYS_PAST NUMBER

DAYS_LATE_BEYOND_LADATE NUMBER

DAYS_LATE_ARRIVAL NUMBER

EXCESS_DURATION NUMBER

RESCHEDULE_IN_DAYS NUMBER

RESCHEDULE_OUT_DAYS NUMBER

QTY_MISMATCH_PCT NUMBER

SS_QUANTITY NUMBER

SHORTAGE_DURATION NUMBER

JUST_DATE DATE

TO_PLANNING_GROUP VARCHAR2 (30)
DEST_ORGANIZATION_ID NUMBER

DEST_SR_INSTANCE_ID NUMBER
Yes
DEST_ORGANIZATION_CODE VARCHAR2 (4000)
CUSTOMER_ITEM_NAME VARCHAR2 (0)
CUSTOMER_PO VARCHAR2 (0)
CUSTOMER_PO_CREATION_DATE DATE

CUSTOMER_PO_LINE VARCHAR2 (0)
CUSTOMER_PO_NEED_BY_DATE DATE

CUSTOMER_PO_QUANTITY NUMBER

CUSTOMER_PO_RECEIPT_DATE DATE

CUSTOMER_PO_CANCEL_DATE DATE

CUSTOMER_PO_UPDATED_DATE DATE

CUSTOMER_PO_RELEASE VARCHAR2 (0)
DAYS_EARLY NUMBER

DAYS_PAST_DUE NUMBER

EXCESS_QUANTITY NUMBER

EXCESS_QUANTITY_PCT NUMBER

INVENTORY_TURNS NUMBER

PERIOD_END_DATE DATE

PERIOD_START_DATE DATE

PURCHASE_ORDER VARCHAR2 (0)
PO_CREATION_DATE DATE

PO_NEED_BY_DATE DATE

PO_UPDATE_DATE DATE

PO_QUANTITY NUMBER

SALES_ORDER VARCHAR2 (0)
SALES_ORDER_LINE VARCHAR2 (0)
SO_CREATION_DATE DATE

SO_QUANTITY NUMBER

SO_RECEIPT_DATE DATE

SO_SHIP_DATE DATE

SHORTAGE_QUANTITY NUMBER

SHORTAGE_QUANTITY_PCT NUMBER

STOCK_OUTS NUMBER

SUPPLIER_ITEM_NAME VARCHAR2 (0)
SUPPLIER_SO VARCHAR2 (0)
SUPPLIER_SO_CREATION_DATE DATE

SUPPLIER_SO_LINE VARCHAR2 (0)
SUPPLIER_SO_QUANTITY NUMBER

SUPPLIER_SO_RECEIPT_DATE DATE

SUPPLIER_SO_SHIP_DATE DATE

THRESHOLD NUMBER

ITEM_MIN_QTY NUMBER

ITEM_MAX_QTY NUMBER

LEAD_TIME NUMBER

COMPRESSION_DAYS NUMBER

VMI_SHORTAGE NUMBER

VMI_EXCESS NUMBER

COMPANY_ID NUMBER

CUSTOMER_ORDER_FCST_QTY NUMBER

SUPPLY_COMMIT_QTY NUMBER

QTY_ON_HAND NUMBER

QTY_ON_ORDER NUMBER

INVENTORY_STATUS NUMBER

SUPPLIER_FCST_QTY NUMBER

CUSTOMER_FCST_QTY NUMBER

HISTORICAL_FCST_QTY NUMBER

YOUR_FCST_QTY NUMBER

ORDER_FCST_QTY NUMBER

ACTUAL_ORDER_QTY NUMBER

SUPPLIER_SUPPLY_COMMIT_QTY NUMBER

FCST_ERROR NUMBER

FILL_RATE NUMBER

DELIVERY_PERF_PCT NUMBER

MSCX_UDE_PUB_ORDER_TYPE NUMBER

MSCX_PLANNER_CODE VARCHAR2 (0)
MSCX_QUANTITY NUMBER

MSCX_COMP_RECEIPT_DATE DATE

MSCX_COMP_REQUEST_DATE DATE

MSCX_CUST_SHIP_DATE DATE

DMD_SCHEDULE_ORG_CODE VARCHAR2 (4000)
DMD_SCHEDULE_ITEM_NAME VARCHAR2 (4000)
DMD_SCHEDULE_QTY NUMBER

DMD_SCHEDULE_ORDER_NUMBER VARCHAR2 (240)
DMD_SCHEDULE_DUE_DATE DATE

ORIG_SCHED_SHIP_DATE DATE

SCHED_SHIP_DATE DATE

ORIG_SCHED_ARRIVAL_DATE DATE

SCHED_ARRIVAL_DATE DATE

ORIG_SHIP_METHOD VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
ORIG_LEAD_TIME NUMBER

INTRANSIT_LEAD_TIME NUMBER

REQUEST_SHIP_DATE DATE

REQUEST_ARRIVAL_DATE DATE

PROMISE_SHIP_DATE DATE

PROMISE_ARRIVAL_DATE DATE

ATP_OVERRIDE_FLAG VARCHAR2 (4000)
LATEST_ACCEPTABLE_DATE DATE

ORIG_SOURCE_ORG_CODE VARCHAR2 (4000)
ORDER_DATE DATE

EXCEPTION_BIT NUMBER

ORDER_START_DATE DATE

ORDER_DUE_DATE DATE

ORDER_DOCK_DATE DATE

ORDER_SHIP_DATE DATE

PLANNED_BEFORE_PTF VARCHAR2 (4000)
BUDGET_VIOLATION_DATE DATE

BUDGET_NAME VARCHAR2 (4000)
BUDGET_VALUE NUMBER

INVENTORY_VALUE NUMBER

BUDGET_VIOLATION_LEVEL VARCHAR2 (4000)
SPECIFIED_SERVICE_LEVEL NUMBER

ACHIEVED_SERVICE_LEVEL NUMBER

DEMAND_ORGANIZATION_CODE VARCHAR2 (4000)
SHIP_ORGANIZATION_CODE VARCHAR2 (4000)
PRODUCT_FAMILY_ID NUMBER

PRODUCT_FAMILY VARCHAR2 (4000)
SUBSTITUTION_PCT NUMBER

BELOW_SS_QTY_PCT NUMBER

CAUSE VARCHAR2 (4000)
BUDGET_VIOLATION_LEVEL_CODE NUMBER

RESOURCE_GROUP_NAME VARCHAR2 (4000)
REQUIRED_COMPLETION_DATE DATE

SCHEDULED_COMPLETION_DATE DATE

MINIMUM_TRANSFER_QUANTITY NUMBER

ACCEPTABLE_EARLY_DELIVERY NUMBER

SETUP_HOURS NUMBER

AVAILABLE_HOURS NUMBER

LOAD_RATIO_FROM NUMBER

LOAD_RATIO_TO NUMBER

START_DATE_FROM DATE

START_DATE_TO DATE

END_DATE_FROM DATE

END_DATE_TO DATE

LOAD_RATIO_DIFFERENCE NUMBER

LOAD_RATIO_DIFF_THRESHOLD NUMBER

ASSET_GROUP VARCHAR2 (4000)
ASSET_NUMBER VARCHAR2 (30)
ASSET_ACTIVITY VARCHAR2 (4000)
REQUESTED_START_DATE DATE

REQUESTED_COMPLETION_DATE DATE

FROM_ITEM VARCHAR2 (4000)
TO_ITEM VARCHAR2 (4000)
FROM_ORGANIZATION VARCHAR2 (4000)
TO_ORGANIZATION VARCHAR2 (4000)
FROM_SUPPLY_ORDER_NUMBER VARCHAR2 (4000)
TO_SUPPLY_ORDER_NUMBER VARCHAR2 (4000)
FROM_OP_SEQ_NUM NUMBER

TO_OP_SEQ_NUM NUMBER

FROM_RES_SEQ_NUM NUMBER

TO_RES_SEQ_NUM NUMBER

MINIMUM_TIME_OFFSET NUMBER

MAXIMUM_TIME_OFFSET NUMBER

ACTUAL_OFFSET NUMBER

SHELF_LIFE_DAYS NUMBER

LOT_EXPIRATION_DATE DATE

SETUP_TIME_RATIO NUMBER

EXCEPTION_TIME_FENCE NUMBER

EXCEPTION_THRESHOLD_PCT NUMBER

EAM_DAYS_EARLY NUMBER

EAM_DAYS_LATE NUMBER

COMP_DEMAND_DATE DATE

MIN_REMAINING_SHELF_LIFE NUMBER

MIN_REMAINING_SLF_LIFE_PLANNED NUMBER

MIN_REMAINING_SLF_LIFE_SHTFALL NUMBER

MODEL_OPTION_CLASS VARCHAR2 (250)
TO_TRANSACTION_ID NUMBER

CHARGE_NUMBER NUMBER

PLANNED_CHARGE_QUANTITY NUMBER

SUBSTITUTE_ITEM_DESC VARCHAR2 (4000)
CURR_DATE DATE

UPDATED_ARRIVAL_DATE DATE

PRIMARY_COMPONENT VARCHAR2 (4000)
PART_CONDITION VARCHAR2 (4000)
PART_CONDITION_FLAG NUMBER

VISIT_NAME VARCHAR2 (4000)
VISIT_ID VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXCEPTION_ID
,      SOURCE_TYPE
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      EXCEPTION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_CODE
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      CATEGORY_NAME
,      ITEM_SEGMENTS
,      ITEM_DESCRIPTION
,      BUYER_NAME
,      PLANNER_CODE
,      EXCEPTION_TYPE_TEXT
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP_HIDDEN
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PLANNING_GROUP
,      TO_PROJECT_NUMBER
,      TO_TASK_NUMBER
,      DUE_DATE
,      FROM_DATE
,      TO_DATE
,      DAYS_COMPRESSED
,      QUANTITY
,      LOT_NUMBER
,      ORDER_NUMBER
,      SUPPLY_TYPE
,      END_ITEM_SEGMENTS
,      PLANNED_INVENTORY_POINT
,      END_ORDER_NUMBER
,      TRANSACTION_ID
,      DEMAND_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      DEPARTMENT_LINE_CODE
,      RESOURCE_CODE
,      RESOURCE_TYPE
,      RESOURCE_TYPE_CODE
,      UTILIZATION_RATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE
,      ORDER_PRIORITY
,      DMD_SATISFIED_DATE
,      SUBSTITUTE_COMPONENT
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      SOURCE_ORGANIZATION_CODE
,      REPLENISHMENT_DATE
,      END_PEGGING_ID
,      DEMAND_QUANTITY
,      OLD_DUE_DATE
,      ORDER_TYPE
,      ORDER_TYPE_ID
,      BATCHABLE_FLAG
,      MIN_CAPACITY
,      MAX_CAPACITY
,      BATCH_NUMBER
,      REQUIRED_CAPACITY
,      QUANTITY_BY_DUE_DATE
,      RESOURCE_OVER_UTIL_COST
,      ALLOCATED_PERCENTAGE
,      ACTUAL_PERCENTAGE
,      PERCENT_VARIANCE
,      ACTION_TAKEN
,      ROW_ID
,      DAYS_LATE
,      SUBSTITUTE_ITEM_ID
,      SUBSTITUTE_ITEM_NAME
,      SUBSTITUTE_ORG_ID
,      SUBSTITUTE_ORG_CODE
,      SUBSTITUTE_QTY
,      PREFERENCE
,      ORIGINATION_TYPE_ID
,      ORIGINATION_TYPE
,      DEMAND_DATE_QUANTITY
,      DEMAND_CLASS
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      FIRM_TYPE
,      FIRM_PLANNED_TYPE
,      MIN_START_TIME
,      MIN_LEAD_TIME
,      NEW_DOCK_DATE
,      AVAILABLE_CAPACITY
,      QTY_MISMATCH
,      ACTUAL_DURATION
,      SUPPLY_ORGANIZATION_CODE
,      SUPPLY_ORGANIZATION_ID
,      SUPPLY_SR_INSTANCE_ID
,      SUPPLY_ITEM_SEGMENTS
,      SUPPLY_INVENTORY_ITEM_ID
,      SUPPLY_PLANNER_CODE
,      SUPPLY_ORDER_TYPE
,      SUPPLY_ORDER_TYPE_ID
,      SUPPLY_SUPPLIER_ID
,      SUPPLY_SUPPLIER_NAME
,      SUPPLY_SUPPLIER_SITE_ID
,      SUPPLY_SUPPLIER_SITE
,      SUPPLY_SOURCE_ORG_CODE
,      SUPPLY_SOURCE_ORG_ID
,      SUPPLY_SOURCE_SR_INSTANCE_ID
,      SUPPLY_PLANNING_GROUP
,      SUPPLY_PROJECT_ID
,      SUPPLY_PROJECT_NUMBER
,      SUPPLY_TASK_ID
,      SUPPLY_TASK_NUMBER
,      SALES_ORDER_LINE_PRICE
,      DUE_DATE_QTY_PCT
,      COMPRESSION_PCT
,      CONSTRAINT_PCT
,      DAYS_EARLY_BEFORE_LADATE
,      DAYS_EARLY_ARRIVAL
,      DAYS_PAST
,      DAYS_LATE_BEYOND_LADATE
,      DAYS_LATE_ARRIVAL
,      EXCESS_DURATION
,      RESCHEDULE_IN_DAYS
,      RESCHEDULE_OUT_DAYS
,      QTY_MISMATCH_PCT
,      SS_QUANTITY
,      SHORTAGE_DURATION
,      JUST_DATE
,      TO_PLANNING_GROUP
,      DEST_ORGANIZATION_ID
,      DEST_SR_INSTANCE_ID
,      DEST_ORGANIZATION_CODE
,      CUSTOMER_ITEM_NAME
,      CUSTOMER_PO
,      CUSTOMER_PO_CREATION_DATE
,      CUSTOMER_PO_LINE
,      CUSTOMER_PO_NEED_BY_DATE
,      CUSTOMER_PO_QUANTITY
,      CUSTOMER_PO_RECEIPT_DATE
,      CUSTOMER_PO_CANCEL_DATE
,      CUSTOMER_PO_UPDATED_DATE
,      CUSTOMER_PO_RELEASE
,      DAYS_EARLY
,      DAYS_PAST_DUE
,      EXCESS_QUANTITY
,      EXCESS_QUANTITY_PCT
,      INVENTORY_TURNS
,      PERIOD_END_DATE
,      PERIOD_START_DATE
,      PURCHASE_ORDER
,      PO_CREATION_DATE
,      PO_NEED_BY_DATE
,      PO_UPDATE_DATE
,      PO_QUANTITY
,      SALES_ORDER
,      SALES_ORDER_LINE
,      SO_CREATION_DATE
,      SO_QUANTITY
,      SO_RECEIPT_DATE
,      SO_SHIP_DATE
,      SHORTAGE_QUANTITY
,      SHORTAGE_QUANTITY_PCT
,      STOCK_OUTS
,      SUPPLIER_ITEM_NAME
,      SUPPLIER_SO
,      SUPPLIER_SO_CREATION_DATE
,      SUPPLIER_SO_LINE
,      SUPPLIER_SO_QUANTITY
,      SUPPLIER_SO_RECEIPT_DATE
,      SUPPLIER_SO_SHIP_DATE
,      THRESHOLD
,      ITEM_MIN_QTY
,      ITEM_MAX_QTY
,      LEAD_TIME
,      COMPRESSION_DAYS
,      VMI_SHORTAGE
,      VMI_EXCESS
,      COMPANY_ID
,      CUSTOMER_ORDER_FCST_QTY
,      SUPPLY_COMMIT_QTY
,      QTY_ON_HAND
,      QTY_ON_ORDER
,      INVENTORY_STATUS
,      SUPPLIER_FCST_QTY
,      CUSTOMER_FCST_QTY
,      HISTORICAL_FCST_QTY
,      YOUR_FCST_QTY
,      ORDER_FCST_QTY
,      ACTUAL_ORDER_QTY
,      SUPPLIER_SUPPLY_COMMIT_QTY
,      FCST_ERROR
,      FILL_RATE
,      DELIVERY_PERF_PCT
,      MSCX_UDE_PUB_ORDER_TYPE
,      MSCX_PLANNER_CODE
,      MSCX_QUANTITY
,      MSCX_COMP_RECEIPT_DATE
,      MSCX_COMP_REQUEST_DATE
,      MSCX_CUST_SHIP_DATE
,      DMD_SCHEDULE_ORG_CODE
,      DMD_SCHEDULE_ITEM_NAME
,      DMD_SCHEDULE_QTY
,      DMD_SCHEDULE_ORDER_NUMBER
,      DMD_SCHEDULE_DUE_DATE
,      ORIG_SCHED_SHIP_DATE
,      SCHED_SHIP_DATE
,      ORIG_SCHED_ARRIVAL_DATE
,      SCHED_ARRIVAL_DATE
,      ORIG_SHIP_METHOD
,      SHIP_METHOD
,      ORIG_LEAD_TIME
,      INTRANSIT_LEAD_TIME
,      REQUEST_SHIP_DATE
,      REQUEST_ARRIVAL_DATE
,      PROMISE_SHIP_DATE
,      PROMISE_ARRIVAL_DATE
,      ATP_OVERRIDE_FLAG
,      LATEST_ACCEPTABLE_DATE
,      ORIG_SOURCE_ORG_CODE
,      ORDER_DATE
,      EXCEPTION_BIT
,      ORDER_START_DATE
,      ORDER_DUE_DATE
,      ORDER_DOCK_DATE
,      ORDER_SHIP_DATE
,      PLANNED_BEFORE_PTF
,      BUDGET_VIOLATION_DATE
,      BUDGET_NAME
,      BUDGET_VALUE
,      INVENTORY_VALUE
,      BUDGET_VIOLATION_LEVEL
,      SPECIFIED_SERVICE_LEVEL
,      ACHIEVED_SERVICE_LEVEL
,      DEMAND_ORGANIZATION_CODE
,      SHIP_ORGANIZATION_CODE
,      PRODUCT_FAMILY_ID
,      PRODUCT_FAMILY
,      SUBSTITUTION_PCT
,      BELOW_SS_QTY_PCT
,      CAUSE
,      BUDGET_VIOLATION_LEVEL_CODE
,      RESOURCE_GROUP_NAME
,      REQUIRED_COMPLETION_DATE
,      SCHEDULED_COMPLETION_DATE
,      MINIMUM_TRANSFER_QUANTITY
,      ACCEPTABLE_EARLY_DELIVERY
,      SETUP_HOURS
,      AVAILABLE_HOURS
,      LOAD_RATIO_FROM
,      LOAD_RATIO_TO
,      START_DATE_FROM
,      START_DATE_TO
,      END_DATE_FROM
,      END_DATE_TO
,      LOAD_RATIO_DIFFERENCE
,      LOAD_RATIO_DIFF_THRESHOLD
,      ASSET_GROUP
,      ASSET_NUMBER
,      ASSET_ACTIVITY
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      FROM_ITEM
,      TO_ITEM
,      FROM_ORGANIZATION
,      TO_ORGANIZATION
,      FROM_SUPPLY_ORDER_NUMBER
,      TO_SUPPLY_ORDER_NUMBER
,      FROM_OP_SEQ_NUM
,      TO_OP_SEQ_NUM
,      FROM_RES_SEQ_NUM
,      TO_RES_SEQ_NUM
,      MINIMUM_TIME_OFFSET
,      MAXIMUM_TIME_OFFSET
,      ACTUAL_OFFSET
,      SHELF_LIFE_DAYS
,      LOT_EXPIRATION_DATE
,      SETUP_TIME_RATIO
,      EXCEPTION_TIME_FENCE
,      EXCEPTION_THRESHOLD_PCT
,      EAM_DAYS_EARLY
,      EAM_DAYS_LATE
,      COMP_DEMAND_DATE
,      MIN_REMAINING_SHELF_LIFE
,      MIN_REMAINING_SLF_LIFE_PLANNED
,      MIN_REMAINING_SLF_LIFE_SHTFALL
,      MODEL_OPTION_CLASS
,      TO_TRANSACTION_ID
,      CHARGE_NUMBER
,      PLANNED_CHARGE_QUANTITY
,      SUBSTITUTE_ITEM_DESC
,      CURR_DATE
,      UPDATED_ARRIVAL_DATE
,      PRIMARY_COMPONENT
,      PART_CONDITION
,      PART_CONDITION_FLAG
,      VISIT_NAME
,      VISIT_ID
FROM APPS.MSC_EXCEPTION_DETAILS_V;

Dependencies

[top of page]

APPS.MSC_EXCEPTION_DETAILS_V references the following:

SchemaAPPS
SynonymMSC_DEMANDS
SynonymMSC_EXCEPTION_DETAILS
SynonymMSC_FULL_PEGGING
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_ITEM_CATEGORIES
SynonymMSC_PLANS
SynonymMSC_SUPPLIES
SynonymMSC_SYSTEM_ITEMS
APPS.MSC_EXCEPTION_DETAILS_V is referenced by following:

SchemaAPPS
ViewMSC_ACTION_ORDERS_TREE_V
Package BodyMSC_DS_SCHEDULE - show dependent code
Package BodyMSC_EXP_WF - show dependent code
ViewMSC_PDR_LATE_ORDER_EXC_V
ViewMSC_PDR_MAT_RES_EXC_V
Package BodyMSC_PQ_UTILS - show dependent code