[Home] [Help] [Dependency Information]
Object Name: | MRP_ATP_PROPERTIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_ATP_PROPERTIES_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 |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | ATP session identifier | |
PEGGING_ID | NUMBER | ATP Pegging identifier | ||
FIXED_LEAD_TIME | NUMBER | Fixed Lead Time | ||
VARIABLE_LEAD_TIME | NUMBER | Variable Lead Time | ||
PREPROCESSING_LEAD_TIME | NUMBER | Preprocessing Lead Time | ||
PROCESSING_LEAD_TIME | NUMBER | Processing Lead Time | ||
POSTPROCESSING_LEAD_TIME | NUMBER | Postprocessing Lead Time | ||
INTRANSIT_LEAD_TIME | NUMBER | Intransit Lead Time | ||
SHIP_METHOD | VARCHAR2 | (30) | Ship Method | |
PTF_DATE | DATE | Planning Time Fence Date | ||
REQUIRED_QUANTITY | NUMBER | Qty required | ||
REQUIRED_DATE | DATE | Required Date | ||
ATP_RULE | VARCHAR2 | (80) | ATP Rule | |
INFINITE_TIME_FENCE | DATE | Instransit Time Fence | ||
SUBSTITUTION_WINDOW | NUMBER | Substitution Window | ||
ROUNDING_CONTROL | VARCHAR2 | (80) | Rounding Control settings | |
WEIGHT_CAPACITY | NUMBER | Weight | ||
VOLUME_CAPACITY | NUMBER | Volume Capacity | ||
ATP_FLAG | VARCHAR2 | (80) | ATP Flag attribute | |
ATP_COMPONENT_FLAG | VARCHAR2 | (80) | ATP Component Flag Attribute | |
OPERATION_SEQUENCE_ID | NUMBER | Routing Operation sequence | ||
USAGE | NUMBER | Usage | ||
OFFSET | NUMBER | Offset | ||
EFFICIENCY | NUMBER | Efficiency | ||
UTILIZATION | NUMBER | Utilization | ||
OWNING_DEPARTMENT | VARCHAR2 | (10) | Owning department | |
REVERSE_CUM_YIELD | NUMBER | Reverse Cumulative Yield | ||
BASIS_TYPE | VARCHAR2 | (4000) | Basis Type | |
BATCH_FLAG | VARCHAR2 | (80) | Batch Flag | |
ALLOCATION_RULE | VARCHAR2 | (30) | Allocation Rule | |
PLAN_NAME | VARCHAR2 | (10) | Plan Name | |
VOLUME_UOM | VARCHAR2 | (3) | Volume Unit of Measure | |
WEIGHT_UOM | VARCHAR2 | (3) | Weight Unit of Measure | |
ATF_DATE | DATE | |||
COMPONENT_YIELD_FACTOR | NUMBER | |||
ROUNDING_DIRECTION | NUMBER | |||
SCALING_TYPE | VARCHAR2 | (4000) | ||
SCALE_ROUNDING_VARIANCE | NUMBER | |||
SCALE_MULTIPLE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, PEGGING_ID
, FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME
, PREPROCESSING_LEAD_TIME
, PROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, INTRANSIT_LEAD_TIME
, SHIP_METHOD
, PTF_DATE
, REQUIRED_QUANTITY
, REQUIRED_DATE
, ATP_RULE
, INFINITE_TIME_FENCE
, SUBSTITUTION_WINDOW
, ROUNDING_CONTROL
, WEIGHT_CAPACITY
, VOLUME_CAPACITY
, ATP_FLAG
, ATP_COMPONENT_FLAG
, OPERATION_SEQUENCE_ID
, USAGE
, OFFSET
, EFFICIENCY
, UTILIZATION
, OWNING_DEPARTMENT
, REVERSE_CUM_YIELD
, BASIS_TYPE
, BATCH_FLAG
, ALLOCATION_RULE
, PLAN_NAME
, VOLUME_UOM
, WEIGHT_UOM
, ATF_DATE
, COMPONENT_YIELD_FACTOR
, ROUNDING_DIRECTION
, SCALING_TYPE
, SCALE_ROUNDING_VARIANCE
, SCALE_MULTIPLE
FROM APPS.MRP_ATP_PROPERTIES_V;
APPS.MRP_ATP_PROPERTIES_V is not referenced by any database object
|
|
|