eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

MRP: MRP_ATP_DETAILS_TEMP

MRP.MRP_ATP_DETAILS_TEMP# is referenced by following:

APPS: MRP_ATP_DETAILS_TEMP