DBA Data[Home] [Help] [Dependency Information]

VIEW: MRP.MRP_ATP_DETAILS_TEMP#

Object Details
Object Name: MRP_ATP_DETAILS_TEMP#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

MRP.MRP_ATP_DETAILS_TEMP# references the following:

SchemaMRP
TableMRP_ATP_DETAILS_TEMP
MRP.MRP_ATP_DETAILS_TEMP# is referenced by following:

SchemaAPPS
SynonymMRP_ATP_DETAILS_TEMP