[Home] [Help] [Dependency Information]
Object Name: | MSC_DRP_EXC_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 |
---|---|---|---|---|
EXCEPTION_ID | NUMBER | Yes | ||
PLAN_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
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 | (250) | ||
ITEM_SEGMENTS | VARCHAR2 | (4000) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
BUYER_NAME | VARCHAR2 | (240) | ||
PLANNER_CODE | VARCHAR2 | (10) | ||
EXCEPTION_TYPE_TEXT | VARCHAR2 | (4000) | ||
DUE_DATE | DATE | |||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
QUANTITY | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (80) | ||
ORDER_NUMBER | VARCHAR2 | (4000) | ||
END_ITEM_SEGMENTS | VARCHAR2 | (4000) | ||
TRANSACTION_ID | NUMBER | |||
DEMAND_ID | NUMBER | |||
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) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORG_INSTANCE_ID | NUMBER | |||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
OLD_DUE_DATE | DATE | |||
ORDER_TYPE | VARCHAR2 | (4000) | ||
ORDER_TYPE_ID | NUMBER | |||
REQUIRED_CAPACITY | NUMBER | |||
QUANTITY_BY_DUE_DATE | 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 | |||
DEMAND_CLASS | VARCHAR2 | (34) | ||
MIN_START_TIME | DATE | |||
MIN_LEAD_TIME | NUMBER | |||
NEW_DOCK_DATE | DATE | |||
AVAILABLE_CAPACITY | NUMBER | |||
QTY_MISMATCH | NUMBER | |||
ACTUAL_DURATION | NUMBER | |||
DEST_ORGANIZATION_ID | NUMBER | |||
DEST_SR_INSTANCE_ID | NUMBER | |||
DEST_ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
DEMAND_QUANTITY | NUMBER | |||
END_ORDER_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 | |||
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) | ||
ALLOCATED_QTY | NUMBER | |||
TOTAL_DEMAND_QTY | NUMBER | |||
TOTAL_SUPPLY_QTY | NUMBER | |||
FIXED_LOT_MULTIPLIER | NUMBER | |||
ALLOCATION_RULE | VARCHAR2 | (4000) | ||
ALLOCATION_RULE_TYPE | VARCHAR2 | (4000) | ||
SHIPMENT_ID | NUMBER | |||
AVAILABLE_DATE | DATE | |||
NEED_BY_DATE | DATE | |||
NEW_SHIP_DATE | DATE | |||
BKT_START_DATE | DATE | |||
BKT_END_DATE | DATE | |||
CALENDAR_VIOLATED | VARCHAR2 | (0) | ||
WEIGHT | NUMBER | |||
CUBE | NUMBER | |||
PIECES | NUMBER | |||
WEIGHT_UNDERLOAD | NUMBER | |||
WEIGHT_OVERLOAD | NUMBER | |||
CUBE_UNDERLOAD | NUMBER | |||
CUBE_OVERLOAD | NUMBER | |||
MIN_WEIGHT_ALLOWED | NUMBER | |||
MIN_CUBE_ALLOWED | NUMBER | |||
MAX_WEIGHT_ALLOWED | NUMBER | |||
MAX_CUBE_ALLOWED | NUMBER | |||
MAX_QTY | NUMBER | |||
OLD_QTY | NUMBER | |||
SOURCING_RULE_NAME | VARCHAR2 | (4000) | ||
UNCONST_PAB | NUMBER | |||
TARGET_QTY | NUMBER | |||
PRODUCT_FAMILY_ID | NUMBER | |||
PRODUCT_FAMILY_NAME | VARCHAR2 | (4000) | ||
ORDER_DATE_TYPE_CODE | NUMBER | |||
ALLOCATION_RULE_ID | NUMBER | |||
DURATION_DAYS | NUMBER | |||
DAYS_FROM_TODAY | NUMBER | |||
SOURCE_TYPE | NUMBER | |||
SHORTAGE_QTY | NUMBER | |||
MAX_NEGATIVE_QTY | NUMBER | |||
LATE_QTY | NUMBER | |||
LATE_DATE | DATE | |||
EXPIRED_QTY | NUMBER | |||
EXPIRED_PCT | NUMBER | |||
ORDER_DATE | DATE | |||
ORDER_START_DATE | DATE | |||
CALENDAR_VIOLATION | VARCHAR2 | (4000) | ||
DEMAND_ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
MAX_QTY_COST | NUMBER | |||
FIRM_TYPE | VARCHAR2 | (4000) | ||
PLANNED_BEFORE_PTF | VARCHAR2 | (4000) | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (4000) | ||
MAX_INV_LEVEL | NUMBER | |||
SUBSTITUTION_PCT | NUMBER | |||
BELOW_SS_QTY_PCT | NUMBER | |||
REQUIRED_COMPLETION_DATE | DATE | |||
SCHEDULED_COMPLETION_DATE | DATE | |||
MINIMUM_TRANSFER_QUANTITY | NUMBER | |||
BELOW_TARGET_QTY_PCT | NUMBER | |||
ABOVE_TARGET_QTY_PCT | NUMBER | |||
ABOVE_MAX_INV_LVL_PCT | NUMBER | |||
OVERLOAD_CAPACITY | NUMBER | |||
OVERLOAD_PERCENT | NUMBER | |||
QTY_BY_SPRCSN_ITEM | NUMBER | |||
AMOUNT | NUMBER | |||
QTY_BY_SPRCSN_ITEM_PCT | NUMBER | |||
EXCESS_QTY | NUMBER | |||
EXCESS_THRESHOLD_QTY | NUMBER | |||
EXCESS_COST | NUMBER | |||
EXCESS_QTY_PERCENT | NUMBER | |||
ORIG_ITEM_ID | NUMBER | |||
PART_CONDITION | VARCHAR2 | (4000) | ||
ORIG_ITEM_NAME | VARCHAR2 | (4000) | ||
PART_CONDITION_ID | NUMBER | |||
ACTION_TAKEN_DATE | DATE | Date on which action was taken for this exception. | ||
FIRST_GENERATED_DATE | DATE | Date on which, this exception was first generated | ||
EXCP_AGE | NUMBER |
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;
APPS.MSC_DRP_EXC_DETAILS_V is not referenced by any database object
|
|
|