[Home] [Help] [Dependency Information]
Object Name: | MRP_ATP_DETAILS_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | ||
ORDER_LINE_ID | NUMBER | |||
PEGGING_ID | NUMBER | |||
PARENT_PEGGING_ID | NUMBER | |||
ATP_LEVEL | NUMBER | |||
REQUEST_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_NAME | VARCHAR2 | (250) | ||
ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (7) | ||
DEPARTMENT_ID | NUMBER | |||
DEPARTMENT_CODE | VARCHAR2 | (10) | ||
RESOURCE_ID | NUMBER | |||
RESOURCE_CODE | VARCHAR2 | (16) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_NAME | VARCHAR2 | (80) | ||
SUPPLIER_SITE_ID | NUMBER | |||
SUPPLIER_SITE_NAME | VARCHAR2 | (15) | ||
FROM_ORGANIZATION_ID | NUMBER | |||
FROM_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
FROM_LOCATION_ID | NUMBER | |||
FROM_LOCATION_CODE | VARCHAR2 | (20) | ||
TO_ORGANIZATION_ID | NUMBER | |||
TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TO_LOCATION_ID | NUMBER | |||
TO_LOCATION_CODE | VARCHAR2 | (20) | ||
SHIP_METHOD | VARCHAR2 | (30) | ||
UOM_CODE | VARCHAR2 | (3) | ||
IDENTIFIER1 | NUMBER | |||
IDENTIFIER2 | NUMBER | |||
IDENTIFIER3 | NUMBER | |||
IDENTIFIER4 | NUMBER | |||
SUPPLY_DEMAND_TYPE | NUMBER | |||
SUPPLY_DEMAND_DATE | DATE | |||
SUPPLY_DEMAND_QUANTITY | NUMBER | |||
SUPPLY_DEMAND_SOURCE_TYPE | NUMBER | |||
ALLOCATED_QUANTITY | NUMBER | |||
SOURCE_TYPE | NUMBER | |||
RECORD_TYPE | NUMBER | |||
TOTAL_SUPPLY_QUANTITY | NUMBER | |||
TOTAL_DEMAND_QUANTITY | NUMBER | |||
PERIOD_START_DATE | DATE | |||
PERIOD_QUANTITY | NUMBER | |||
CUMULATIVE_QUANTITY | NUMBER | |||
WEIGHT_CAPACITY | NUMBER | |||
VOLUME_CAPACITY | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (3) | ||
VOLUME_UOM | VARCHAR2 | (3) | ||
PERIOD_END_DATE | DATE | |||
SCENARIO_ID | NUMBER | Yes | ||
DISPOSITION_TYPE | NUMBER | |||
DISPOSITION_NAME | VARCHAR2 | (80) | ||
REQUEST_ITEM_NAME | VARCHAR2 | (250) | ||
SUPPLY_DEMAND_SOURCE_TYPE_NAME | VARCHAR2 | (80) | ||
END_PEGGING_ID | NUMBER | |||
CONSTRAINT_FLAG | VARCHAR2 | (1) | ||
NUMBER1 | NUMBER | |||
CHAR1 | VARCHAR2 | (40) | ||
COMPONENT_IDENTIFIER | NUMBER | |||
BATCHABLE_FLAG | NUMBER | |||
DEST_INV_ITEM_ID | NUMBER | |||
SUPPLIER_ATP_DATE | DATE | |||
SUMMARY_FLAG | VARCHAR2 | (1) | ||
PTF_DATE | DATE | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
FIXED_LEAD_TIME | NUMBER | |||
VARIABLE_LEAD_TIME | NUMBER | |||
PREPROCESSING_LEAD_TIME | NUMBER | |||
PROCESSING_LEAD_TIME | NUMBER | |||
POSTPROCESSING_LEAD_TIME | NUMBER | |||
INTRANSIT_LEAD_TIME | NUMBER | |||
ATP_RULE_ID | NUMBER | |||
ALLOCATION_RULE | VARCHAR2 | (30) | ||
INFINITE_TIME_FENCE | DATE | |||
SUBSTITUTION_WINDOW | NUMBER | |||
REQUIRED_QUANTITY | NUMBER | |||
ROUNDING_CONTROL | NUMBER | |||
ATP_FLAG | VARCHAR2 | (1) | ||
ATP_COMPONENT_FLAG | VARCHAR2 | (1) | ||
REQUIRED_DATE | DATE | |||
OPERATION_SEQUENCE_ID | NUMBER | |||
SOURCING_RULE_NAME | VARCHAR2 | (30) | ||
OFFSET | NUMBER | |||
EFFICIENCY | NUMBER | |||
OWNING_DEPARTMENT | VARCHAR2 | (10) | ||
REVERSE_CUM_YIELD | NUMBER | |||
BASIS_TYPE | NUMBER | |||
USAGE | NUMBER | |||
CONSTRAINT_TYPE | NUMBER | |||
CONSTRAINT_DATE | DATE | |||
CRITICAL_PATH | NUMBER | |||
PEGGING_TYPE | NUMBER | |||
UTILIZATION | NUMBER | |||
ATP_RULE_NAME | VARCHAR2 | (80) | ||
PLAN_NAME | VARCHAR2 | (10) | ||
CONSTRAINED_PATH | NUMBER | |||
PLAN_ID | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (80) | ||
CLASS | VARCHAR2 | (80) | ||
CUSTOMER_NAME | VARCHAR2 | (80) | ||
CUSTOMER_SITE_NAME | VARCHAR2 | (80) | ||
ALLOCATED_SUPPLY_QUANTITY | NUMBER | |||
SUPPLY_ADJUSTMENT_QUANTITY | NUMBER | |||
BACKWARD_FORWARD_QUANTITY | NUMBER | |||
BACKWARD_QUANTITY | NUMBER | |||
DEMAND_ADJUSTMENT_QUANTITY | NUMBER | |||
ADJUSTED_AVAILABILITY_QUANTITY | NUMBER | |||
ALLOCATION_PERCENT | NUMBER | |||
ACTUAL_ALLOCATION_PERCENT | NUMBER | |||
ADJUSTED_CUM_QUANTITY | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
BASE_MODEL_ID | NUMBER | |||
BASE_MODEL_NAME | VARCHAR2 | (255) | ||
MODEL_SD_FLAG | NUMBER | |||
ERROR_CODE | NUMBER | |||
TOTAL_BUCKETED_DEMAND_QUANTITY | NUMBER | |||
AGGREGATE_TIME_FENCE_DATE | DATE | |||
PF_DISPLAY_FLAG | NUMBER | |||
ORIGINAL_DEMAND_DATE | DATE | |||
ORIGINAL_DEMAND_QUANTITY | NUMBER | |||
ORIGINAL_ITEM_ID | NUMBER | |||
ORIGINAL_SUPPLY_DEMAND_TYPE | NUMBER | |||
NONATP_FLAG | NUMBER | |||
RECEIVING_ORGANIZATION_ID | NUMBER | |||
UNALLOCATED_QUANTITY | NUMBER | |||
ORIG_CUSTOMER_SITE_NAME | VARCHAR2 | (255) | ||
ORIG_CUSTOMER_NAME | VARCHAR2 | (60) | ||
ORIG_DEMAND_CLASS | VARCHAR2 | (34) | ||
ORIG_REQUEST_DATE | DATE | |||
ACTUAL_SUPPLY_DEMAND_DATE | DATE | |||
SHIPPING_CAL_CODE | VARCHAR2 | (14) | ||
RECEIVING_CAL_CODE | VARCHAR2 | (14) | ||
INTRANSIT_CAL_CODE | VARCHAR2 | (14) | ||
MANUFACTURING_CAL_CODE | VARCHAR2 | (14) | ||
COMPONENT_YIELD_FACTOR | NUMBER | |||
SCALING_TYPE | NUMBER | |||
ROUNDING_DIRECTION | NUMBER | |||
SCALE_ROUNDING_VARIANCE | NUMBER | |||
SCALE_MULTIPLE | NUMBER | |||
ORGANIZATION_TYPE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ORDER_LINE_ID
, PEGGING_ID
, PARENT_PEGGING_ID
, ATP_LEVEL
, REQUEST_ITEM_ID
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, ORGANIZATION_ID
, ORGANIZATION_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, RESOURCE_ID
, RESOURCE_CODE
, SUPPLIER_ID
, SUPPLIER_NAME
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME
, FROM_ORGANIZATION_ID
, FROM_ORGANIZATION_CODE
, FROM_LOCATION_ID
, FROM_LOCATION_CODE
, TO_ORGANIZATION_ID
, TO_ORGANIZATION_CODE
, TO_LOCATION_ID
, TO_LOCATION_CODE
, SHIP_METHOD
, UOM_CODE
, IDENTIFIER1
, IDENTIFIER2
, IDENTIFIER3
, IDENTIFIER4
, SUPPLY_DEMAND_TYPE
, SUPPLY_DEMAND_DATE
, SUPPLY_DEMAND_QUANTITY
, SUPPLY_DEMAND_SOURCE_TYPE
, ALLOCATED_QUANTITY
, SOURCE_TYPE
, RECORD_TYPE
, TOTAL_SUPPLY_QUANTITY
, TOTAL_DEMAND_QUANTITY
, PERIOD_START_DATE
, PERIOD_QUANTITY
, CUMULATIVE_QUANTITY
, WEIGHT_CAPACITY
, VOLUME_CAPACITY
, WEIGHT_UOM
, VOLUME_UOM
, PERIOD_END_DATE
, SCENARIO_ID
, DISPOSITION_TYPE
, DISPOSITION_NAME
, REQUEST_ITEM_NAME
, SUPPLY_DEMAND_SOURCE_TYPE_NAME
, END_PEGGING_ID
, CONSTRAINT_FLAG
, NUMBER1
, CHAR1
, COMPONENT_IDENTIFIER
, BATCHABLE_FLAG
, DEST_INV_ITEM_ID
, SUPPLIER_ATP_DATE
, SUMMARY_FLAG
, PTF_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME
, PREPROCESSING_LEAD_TIME
, PROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, INTRANSIT_LEAD_TIME
, ATP_RULE_ID
, ALLOCATION_RULE
, INFINITE_TIME_FENCE
, SUBSTITUTION_WINDOW
, REQUIRED_QUANTITY
, ROUNDING_CONTROL
, ATP_FLAG
, ATP_COMPONENT_FLAG
, REQUIRED_DATE
, OPERATION_SEQUENCE_ID
, SOURCING_RULE_NAME
, OFFSET
, EFFICIENCY
, OWNING_DEPARTMENT
, REVERSE_CUM_YIELD
, BASIS_TYPE
, USAGE
, CONSTRAINT_TYPE
, CONSTRAINT_DATE
, CRITICAL_PATH
, PEGGING_TYPE
, UTILIZATION
, ATP_RULE_NAME
, PLAN_NAME
, CONSTRAINED_PATH
, PLAN_ID
, DEMAND_CLASS
, CLASS
, CUSTOMER_NAME
, CUSTOMER_SITE_NAME
, ALLOCATED_SUPPLY_QUANTITY
, SUPPLY_ADJUSTMENT_QUANTITY
, BACKWARD_FORWARD_QUANTITY
, BACKWARD_QUANTITY
, DEMAND_ADJUSTMENT_QUANTITY
, ADJUSTED_AVAILABILITY_QUANTITY
, ALLOCATION_PERCENT
, ACTUAL_ALLOCATION_PERCENT
, ADJUSTED_CUM_QUANTITY
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, BASE_MODEL_ID
, BASE_MODEL_NAME
, MODEL_SD_FLAG
, ERROR_CODE
, TOTAL_BUCKETED_DEMAND_QUANTITY
, AGGREGATE_TIME_FENCE_DATE
, PF_DISPLAY_FLAG
, ORIGINAL_DEMAND_DATE
, ORIGINAL_DEMAND_QUANTITY
, ORIGINAL_ITEM_ID
, ORIGINAL_SUPPLY_DEMAND_TYPE
, NONATP_FLAG
, RECEIVING_ORGANIZATION_ID
, UNALLOCATED_QUANTITY
, ORIG_CUSTOMER_SITE_NAME
, ORIG_CUSTOMER_NAME
, ORIG_DEMAND_CLASS
, ORIG_REQUEST_DATE
, ACTUAL_SUPPLY_DEMAND_DATE
, SHIPPING_CAL_CODE
, RECEIVING_CAL_CODE
, INTRANSIT_CAL_CODE
, MANUFACTURING_CAL_CODE
, COMPONENT_YIELD_FACTOR
, SCALING_TYPE
, ROUNDING_DIRECTION
, SCALE_ROUNDING_VARIANCE
, SCALE_MULTIPLE
, ORGANIZATION_TYPE
FROM MRP.MRP_ATP_DETAILS_TEMP#;
|
|
|