VIEW: MRP.MRP_ATP_DETAILS_TEMP#

Source

View Text - Preformatted

select SESSION_ID SESSION_ID, ORDER_LINE_ID ORDER_LINE_ID, PEGGING_ID PEGGING_ID, PARENT_PEGGING_ID PARENT_PEGGING_ID, ATP_LEVEL ATP_LEVEL, REQUEST_ITEM_ID REQUEST_ITEM_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, RESOURCE_ID RESOURCE_ID, RESOURCE_CODE RESOURCE_CODE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE, FROM_LOCATION_ID FROM_LOCATION_ID, FROM_LOCATION_CODE FROM_LOCATION_CODE, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE, TO_LOCATION_ID TO_LOCATION_ID, TO_LOCATION_CODE TO_LOCATION_CODE, SHIP_METHOD SHIP_METHOD, UOM_CODE UOM_CODE, IDENTIFIER1 IDENTIFIER1, IDENTIFIER2 IDENTIFIER2, IDENTIFIER3 IDENTIFIER3, IDENTIFIER4 IDENTIFIER4, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE, SUPPLY_DEMAND_DATE SUPPLY_DEMAND_DATE, SUPPLY_DEMAND_QUANTITY SUPPLY_DEMAND_QUANTITY, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE, ALLOCATED_QUANTITY ALLOCATED_QUANTITY, SOURCE_TYPE SOURCE_TYPE, RECORD_TYPE RECORD_TYPE, TOTAL_SUPPLY_QUANTITY TOTAL_SUPPLY_QUANTITY, TOTAL_DEMAND_QUANTITY TOTAL_DEMAND_QUANTITY, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_QUANTITY PERIOD_QUANTITY, CUMULATIVE_QUANTITY CUMULATIVE_QUANTITY, WEIGHT_CAPACITY WEIGHT_CAPACITY, VOLUME_CAPACITY VOLUME_CAPACITY, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, PERIOD_END_DATE PERIOD_END_DATE, SCENARIO_ID SCENARIO_ID, DISPOSITION_TYPE DISPOSITION_TYPE, DISPOSITION_NAME DISPOSITION_NAME, REQUEST_ITEM_NAME REQUEST_ITEM_NAME, SUPPLY_DEMAND_SOURCE_TYPE_NAME SUPPLY_DEMAND_SOURCE_TYPE_NAME, END_PEGGING_ID END_PEGGING_ID, CONSTRAINT_FLAG CONSTRAINT_FLAG, NUMBER1 NUMBER1, CHAR1 CHAR1, COMPONENT_IDENTIFIER COMPONENT_IDENTIFIER, BATCHABLE_FLAG BATCHABLE_FLAG, DEST_INV_ITEM_ID DEST_INV_ITEM_ID, SUPPLIER_ATP_DATE SUPPLIER_ATP_DATE, SUMMARY_FLAG SUMMARY_FLAG, PTF_DATE PTF_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, ATP_RULE_ID ATP_RULE_ID, ALLOCATION_RULE ALLOCATION_RULE, INFINITE_TIME_FENCE INFINITE_TIME_FENCE, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW, REQUIRED_QUANTITY REQUIRED_QUANTITY, ROUNDING_CONTROL ROUNDING_CONTROL, ATP_FLAG ATP_FLAG, ATP_COMPONENT_FLAG ATP_COMPONENT_FLAG, REQUIRED_DATE REQUIRED_DATE, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, SOURCING_RULE_NAME SOURCING_RULE_NAME, OFFSET OFFSET, EFFICIENCY EFFICIENCY, OWNING_DEPARTMENT OWNING_DEPARTMENT, REVERSE_CUM_YIELD REVERSE_CUM_YIELD, BASIS_TYPE BASIS_TYPE, USAGE USAGE, CONSTRAINT_TYPE CONSTRAINT_TYPE, CONSTRAINT_DATE CONSTRAINT_DATE, CRITICAL_PATH CRITICAL_PATH, PEGGING_TYPE PEGGING_TYPE, UTILIZATION UTILIZATION, ATP_RULE_NAME ATP_RULE_NAME, PLAN_NAME PLAN_NAME, CONSTRAINED_PATH CONSTRAINED_PATH, PLAN_ID PLAN_ID, DEMAND_CLASS DEMAND_CLASS, CLASS CLASS, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, ALLOCATED_SUPPLY_QUANTITY ALLOCATED_SUPPLY_QUANTITY, SUPPLY_ADJUSTMENT_QUANTITY SUPPLY_ADJUSTMENT_QUANTITY, BACKWARD_FORWARD_QUANTITY BACKWARD_FORWARD_QUANTITY, BACKWARD_QUANTITY BACKWARD_QUANTITY, DEMAND_ADJUSTMENT_QUANTITY DEMAND_ADJUSTMENT_QUANTITY, ADJUSTED_AVAILABILITY_QUANTITY ADJUSTED_AVAILABILITY_QUANTITY, ALLOCATION_PERCENT ALLOCATION_PERCENT, ACTUAL_ALLOCATION_PERCENT ACTUAL_ALLOCATION_PERCENT, ADJUSTED_CUM_QUANTITY ADJUSTED_CUM_QUANTITY, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, BASE_MODEL_ID BASE_MODEL_ID, BASE_MODEL_NAME BASE_MODEL_NAME, MODEL_SD_FLAG MODEL_SD_FLAG, ERROR_CODE ERROR_CODE, TOTAL_BUCKETED_DEMAND_QUANTITY TOTAL_BUCKETED_DEMAND_QUANTITY, AGGREGATE_TIME_FENCE_DATE AGGREGATE_TIME_FENCE_DATE, PF_DISPLAY_FLAG PF_DISPLAY_FLAG, ORIGINAL_DEMAND_DATE ORIGINAL_DEMAND_DATE, ORIGINAL_DEMAND_QUANTITY ORIGINAL_DEMAND_QUANTITY, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, ORIGINAL_SUPPLY_DEMAND_TYPE ORIGINAL_SUPPLY_DEMAND_TYPE, NONATP_FLAG NONATP_FLAG, RECEIVING_ORGANIZATION_ID RECEIVING_ORGANIZATION_ID, UNALLOCATED_QUANTITY UNALLOCATED_QUANTITY, ORIG_CUSTOMER_SITE_NAME ORIG_CUSTOMER_SITE_NAME, ORIG_CUSTOMER_NAME ORIG_CUSTOMER_NAME, ORIG_DEMAND_CLASS ORIG_DEMAND_CLASS, ORIG_REQUEST_DATE ORIG_REQUEST_DATE, ACTUAL_SUPPLY_DEMAND_DATE ACTUAL_SUPPLY_DEMAND_DATE, SHIPPING_CAL_CODE SHIPPING_CAL_CODE, RECEIVING_CAL_CODE RECEIVING_CAL_CODE, INTRANSIT_CAL_CODE INTRANSIT_CAL_CODE, MANUFACTURING_CAL_CODE MANUFACTURING_CAL_CODE, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR, SCALING_TYPE SCALING_TYPE, ROUNDING_DIRECTION ROUNDING_DIRECTION, SCALE_ROUNDING_VARIANCE SCALE_ROUNDING_VARIANCE, SCALE_MULTIPLE SCALE_MULTIPLE, ORGANIZATION_TYPE ORGANIZATION_TYPE from "MRP"."MRP_ATP_DETAILS_TEMP"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, ORDER_LINE_ID ORDER_LINE_ID
, PEGGING_ID PEGGING_ID
, PARENT_PEGGING_ID PARENT_PEGGING_ID
, ATP_LEVEL ATP_LEVEL
, REQUEST_ITEM_ID REQUEST_ITEM_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, RESOURCE_ID RESOURCE_ID
, RESOURCE_CODE RESOURCE_CODE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, FROM_LOCATION_ID FROM_LOCATION_ID
, FROM_LOCATION_CODE FROM_LOCATION_CODE
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE
, TO_LOCATION_ID TO_LOCATION_ID
, TO_LOCATION_CODE TO_LOCATION_CODE
, SHIP_METHOD SHIP_METHOD
, UOM_CODE UOM_CODE
, IDENTIFIER1 IDENTIFIER1
, IDENTIFIER2 IDENTIFIER2
, IDENTIFIER3 IDENTIFIER3
, IDENTIFIER4 IDENTIFIER4
, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE
, SUPPLY_DEMAND_DATE SUPPLY_DEMAND_DATE
, SUPPLY_DEMAND_QUANTITY SUPPLY_DEMAND_QUANTITY
, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE
, ALLOCATED_QUANTITY ALLOCATED_QUANTITY
, SOURCE_TYPE SOURCE_TYPE
, RECORD_TYPE RECORD_TYPE
, TOTAL_SUPPLY_QUANTITY TOTAL_SUPPLY_QUANTITY
, TOTAL_DEMAND_QUANTITY TOTAL_DEMAND_QUANTITY
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_QUANTITY PERIOD_QUANTITY
, CUMULATIVE_QUANTITY CUMULATIVE_QUANTITY
, WEIGHT_CAPACITY WEIGHT_CAPACITY
, VOLUME_CAPACITY VOLUME_CAPACITY
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, PERIOD_END_DATE PERIOD_END_DATE
, SCENARIO_ID SCENARIO_ID
, DISPOSITION_TYPE DISPOSITION_TYPE
, DISPOSITION_NAME DISPOSITION_NAME
, REQUEST_ITEM_NAME REQUEST_ITEM_NAME
, SUPPLY_DEMAND_SOURCE_TYPE_NAME SUPPLY_DEMAND_SOURCE_TYPE_NAME
, END_PEGGING_ID END_PEGGING_ID
, CONSTRAINT_FLAG CONSTRAINT_FLAG
, NUMBER1 NUMBER1
, CHAR1 CHAR1
, COMPONENT_IDENTIFIER COMPONENT_IDENTIFIER
, BATCHABLE_FLAG BATCHABLE_FLAG
, DEST_INV_ITEM_ID DEST_INV_ITEM_ID
, SUPPLIER_ATP_DATE SUPPLIER_ATP_DATE
, SUMMARY_FLAG SUMMARY_FLAG
, PTF_DATE PTF_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, ATP_RULE_ID ATP_RULE_ID
, ALLOCATION_RULE ALLOCATION_RULE
, INFINITE_TIME_FENCE INFINITE_TIME_FENCE
, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW
, REQUIRED_QUANTITY REQUIRED_QUANTITY
, ROUNDING_CONTROL ROUNDING_CONTROL
, ATP_FLAG ATP_FLAG
, ATP_COMPONENT_FLAG ATP_COMPONENT_FLAG
, REQUIRED_DATE REQUIRED_DATE
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, SOURCING_RULE_NAME SOURCING_RULE_NAME
, OFFSET OFFSET
, EFFICIENCY EFFICIENCY
, OWNING_DEPARTMENT OWNING_DEPARTMENT
, REVERSE_CUM_YIELD REVERSE_CUM_YIELD
, BASIS_TYPE BASIS_TYPE
, USAGE USAGE
, CONSTRAINT_TYPE CONSTRAINT_TYPE
, CONSTRAINT_DATE CONSTRAINT_DATE
, CRITICAL_PATH CRITICAL_PATH
, PEGGING_TYPE PEGGING_TYPE
, UTILIZATION UTILIZATION
, ATP_RULE_NAME ATP_RULE_NAME
, PLAN_NAME PLAN_NAME
, CONSTRAINED_PATH CONSTRAINED_PATH
, PLAN_ID PLAN_ID
, DEMAND_CLASS DEMAND_CLASS
, CLASS CLASS
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, ALLOCATED_SUPPLY_QUANTITY ALLOCATED_SUPPLY_QUANTITY
, SUPPLY_ADJUSTMENT_QUANTITY SUPPLY_ADJUSTMENT_QUANTITY
, BACKWARD_FORWARD_QUANTITY BACKWARD_FORWARD_QUANTITY
, BACKWARD_QUANTITY BACKWARD_QUANTITY
, DEMAND_ADJUSTMENT_QUANTITY DEMAND_ADJUSTMENT_QUANTITY
, ADJUSTED_AVAILABILITY_QUANTITY ADJUSTED_AVAILABILITY_QUANTITY
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, ACTUAL_ALLOCATION_PERCENT ACTUAL_ALLOCATION_PERCENT
, ADJUSTED_CUM_QUANTITY ADJUSTED_CUM_QUANTITY
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, BASE_MODEL_ID BASE_MODEL_ID
, BASE_MODEL_NAME BASE_MODEL_NAME
, MODEL_SD_FLAG MODEL_SD_FLAG
, ERROR_CODE ERROR_CODE
, TOTAL_BUCKETED_DEMAND_QUANTITY TOTAL_BUCKETED_DEMAND_QUANTITY
, AGGREGATE_TIME_FENCE_DATE AGGREGATE_TIME_FENCE_DATE
, PF_DISPLAY_FLAG PF_DISPLAY_FLAG
, ORIGINAL_DEMAND_DATE ORIGINAL_DEMAND_DATE
, ORIGINAL_DEMAND_QUANTITY ORIGINAL_DEMAND_QUANTITY
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, ORIGINAL_SUPPLY_DEMAND_TYPE ORIGINAL_SUPPLY_DEMAND_TYPE
, NONATP_FLAG NONATP_FLAG
, RECEIVING_ORGANIZATION_ID RECEIVING_ORGANIZATION_ID
, UNALLOCATED_QUANTITY UNALLOCATED_QUANTITY
, ORIG_CUSTOMER_SITE_NAME ORIG_CUSTOMER_SITE_NAME
, ORIG_CUSTOMER_NAME ORIG_CUSTOMER_NAME
, ORIG_DEMAND_CLASS ORIG_DEMAND_CLASS
, ORIG_REQUEST_DATE ORIG_REQUEST_DATE
, ACTUAL_SUPPLY_DEMAND_DATE ACTUAL_SUPPLY_DEMAND_DATE
, SHIPPING_CAL_CODE SHIPPING_CAL_CODE
, RECEIVING_CAL_CODE RECEIVING_CAL_CODE
, INTRANSIT_CAL_CODE INTRANSIT_CAL_CODE
, MANUFACTURING_CAL_CODE MANUFACTURING_CAL_CODE
, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR
, SCALING_TYPE SCALING_TYPE
, ROUNDING_DIRECTION ROUNDING_DIRECTION
, SCALE_ROUNDING_VARIANCE SCALE_ROUNDING_VARIANCE
, SCALE_MULTIPLE SCALE_MULTIPLE
, ORGANIZATION_TYPE ORGANIZATION_TYPE
FROM "MRP"."MRP_ATP_DETAILS_TEMP"