[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_DRP_EXC_DETAILS_V

Object Details

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 EXCEPTION_ID
,      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
,      DUE_DATE
,      FROM_DATE
,      TO_DATE
,      QUANTITY
,      LOT_NUMBER
,      ORDER_NUMBER
,      END_ITEM_SEGMENTS
,      TRANSACTION_ID
,      DEMAND_ID
,      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
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      SOURCE_ORGANIZATION_CODE
,      OLD_DUE_DATE
,      ORDER_TYPE
,      ORDER_TYPE_ID
,      REQUIRED_CAPACITY
,      QUANTITY_BY_DUE_DATE
,      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
,      DEMAND_CLASS
,      MIN_START_TIME
,      MIN_LEAD_TIME
,      NEW_DOCK_DATE
,      AVAILABLE_CAPACITY
,      QTY_MISMATCH
,      ACTUAL_DURATION
,      DEST_ORGANIZATION_ID
,      DEST_SR_INSTANCE_ID
,      DEST_ORGANIZATION_CODE
,      DEMAND_QUANTITY
,      END_ORDER_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
,      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
,      ALLOCATED_QTY
,      TOTAL_DEMAND_QTY
,      TOTAL_SUPPLY_QTY
,      FIXED_LOT_MULTIPLIER
,      ALLOCATION_RULE
,      ALLOCATION_RULE_TYPE
,      SHIPMENT_ID
,      AVAILABLE_DATE
,      NEED_BY_DATE
,      NEW_SHIP_DATE
,      BKT_START_DATE
,      BKT_END_DATE
,      CALENDAR_VIOLATED
,      WEIGHT
,      CUBE
,      PIECES
,      WEIGHT_UNDERLOAD
,      WEIGHT_OVERLOAD
,      CUBE_UNDERLOAD
,      CUBE_OVERLOAD
,      MIN_WEIGHT_ALLOWED
,      MIN_CUBE_ALLOWED
,      MAX_WEIGHT_ALLOWED
,      MAX_CUBE_ALLOWED
,      MAX_QTY
,      OLD_QTY
,      SOURCING_RULE_NAME
,      UNCONST_PAB
,      TARGET_QTY
,      PRODUCT_FAMILY_ID
,      PRODUCT_FAMILY_NAME
,      ORDER_DATE_TYPE_CODE
,      ALLOCATION_RULE_ID
,      DURATION_DAYS
,      DAYS_FROM_TODAY
,      SOURCE_TYPE
,      SHORTAGE_QTY
,      MAX_NEGATIVE_QTY
,      LATE_QTY
,      LATE_DATE
,      EXPIRED_QTY
,      EXPIRED_PCT
,      ORDER_DATE
,      ORDER_START_DATE
,      CALENDAR_VIOLATION
,      DEMAND_ORGANIZATION_CODE
,      MAX_QTY_COST
,      FIRM_TYPE
,      PLANNED_BEFORE_PTF
,      ALTERNATE_BOM_DESIGNATOR
,      MAX_INV_LEVEL
,      SUBSTITUTION_PCT
,      BELOW_SS_QTY_PCT
,      REQUIRED_COMPLETION_DATE
,      SCHEDULED_COMPLETION_DATE
,      MINIMUM_TRANSFER_QUANTITY
,      BELOW_TARGET_QTY_PCT
,      ABOVE_TARGET_QTY_PCT
,      ABOVE_MAX_INV_LVL_PCT
,      OVERLOAD_CAPACITY
,      OVERLOAD_PERCENT
,      QTY_BY_SPRCSN_ITEM
,      AMOUNT
,      QTY_BY_SPRCSN_ITEM_PCT
,      EXCESS_QTY
,      EXCESS_THRESHOLD_QTY
,      EXCESS_COST
,      EXCESS_QTY_PERCENT
,      ORIG_ITEM_ID
,      PART_CONDITION
,      ORIG_ITEM_NAME
,      PART_CONDITION_ID
,      ACTION_TAKEN_DATE
,      FIRST_GENERATED_DATE
,      EXCP_AGE
FROM APPS.MSC_DRP_EXC_DETAILS_V;

Dependencies

[top of page]

APPS

MSC_DEMANDS

MSC_DRP_UTIL - show dependent code

MSC_EXCEPTION_DETAILS

MSC_GET_NAME - show dependent code

MSC_ITEM_CATEGORIES

MSC_PLANS

MSC_SHIPMENTS

MSC_SUPPLIES

MSC_SYSTEM_ITEMS

APPS.MSC_DRP_EXC_DETAILS_V is not referenced by any database object