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

TABLE: MRP.MRP_ATP_DETAILS_TEMP

Object Details
Object Name: MRP_ATP_DETAILS_TEMP
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_ATP_DETAILS_TEMP
Subobject Name:
Status: VALID


MRP_ATP_DETAILS_TEMP stores the detail records of an ATP inquiry or demand process. The column record_type identifies whether the record is a Supply/Demand, Horizontal ATP or sourcing
record. The session_id and order_line_id are foreign keys to the table MRP_ATP_SCHEDULE_TEMP.
This table holds records only for the duration of the session identified by the session_id where a session is an ATP inquiry or demanding process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_ATP_DETAILS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnORDER_LINE_ID
ColumnRECORD_TYPE
ColumnSCENARIO_ID
MRP_ATP_DETAILS_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnPEGGING_ID
ColumnRECORD_TYPE
MRP_ATP_DETAILS_TEMP_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_PEGGING_ID
ColumnPEGGING_ID
ColumnRECORD_TYPE
MRP_ATP_DETAILS_TEMP_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnRECORD_TYPE
ColumnPARENT_PEGGING_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Session Identifier
ORDER_LINE_ID NUMBER

Sales Order Line Id
PEGGING_ID NUMBER

Pegging Id
PARENT_PEGGING_ID NUMBER

Parent Pegging Id
ATP_LEVEL NUMBER

Depth in pegging tree
REQUEST_ITEM_ID NUMBER

Request Item Id
INVENTORY_ITEM_ID NUMBER

Item Id
INVENTORY_ITEM_NAME VARCHAR2 (250)
Item name
ORGANIZATION_ID NUMBER

Organization Id
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
DEPARTMENT_ID NUMBER

Department Id
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
RESOURCE_ID NUMBER

Resource Id
RESOURCE_CODE VARCHAR2 (16)
Resource Code
SUPPLIER_ID NUMBER

Supplier Id
SUPPLIER_NAME VARCHAR2 (80)
Supplier Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Id
SUPPLIER_SITE_NAME VARCHAR2 (15)
Supplier Site Name
FROM_ORGANIZATION_ID NUMBER

From Organization Id
FROM_ORGANIZATION_CODE VARCHAR2 (3)
From Organization Code
FROM_LOCATION_ID NUMBER

From Location Id
FROM_LOCATION_CODE VARCHAR2 (20)
From Location Code
TO_ORGANIZATION_ID NUMBER

To Organization Id
TO_ORGANIZATION_CODE VARCHAR2 (3)
To Organization Code
TO_LOCATION_ID NUMBER

To Location Id
TO_LOCATION_CODE VARCHAR2 (20)
To Location Code
SHIP_METHOD VARCHAR2 (30)
Shipping Method
UOM_CODE VARCHAR2 (3)
Unit Of Measure
IDENTIFIER1 NUMBER

Identifier1. Holds sales order line id.
IDENTIFIER2 NUMBER

Identifier2. Holds plan_id for demand and PO supply pegging.
IDENTIFIER3 NUMBER

Identifier3. Holds transaction_id or demand_id for PO supply and demand pegging lines
IDENTIFIER4 NUMBER

Identifier4
SUPPLY_DEMAND_TYPE NUMBER

1 for demand. 2 for supply
SUPPLY_DEMAND_DATE DATE

Supply Demand Date
SUPPLY_DEMAND_QUANTITY NUMBER

Supply Demand Quantity
SUPPLY_DEMAND_SOURCE_TYPE NUMBER

(1) Purchase Order, (2) Sales Order, etc
ALLOCATED_QUANTITY NUMBER

Quantity stolen in allocated ATP
SOURCE_TYPE NUMBER

(1)Transfer, (2)Make, (3)Buy
RECORD_TYPE NUMBER

(1) Period record, (2) Supply/Demand details, (3) Pegging
TOTAL_SUPPLY_QUANTITY NUMBER

Total Supply Quantity
TOTAL_DEMAND_QUANTITY NUMBER

Total Demand Quantity (negative)
PERIOD_START_DATE DATE

Period Start Date
PERIOD_QUANTITY NUMBER

Total_Supply_Quantity + Total_Demand_Quantity
CUMULATIVE_QUANTITY NUMBER

Cumulative quantity over all periods
WEIGHT_CAPACITY NUMBER

Weight Capacity
VOLUME_CAPACITY NUMBER

Volume Capacity
WEIGHT_UOM VARCHAR2 (3)
Weight unit of measure
VOLUME_UOM VARCHAR2 (3)
Volume unit of measure
PERIOD_END_DATE DATE

Period End Date
SCENARIO_ID NUMBER
Yes (-1) if called from view allocation
DISPOSITION_TYPE NUMBER

Disposition Type (unused)
DISPOSITION_NAME VARCHAR2 (80)
Disposition Name/Order number
REQUEST_ITEM_NAME VARCHAR2 (250)
Requested Item's Name
SUPPLY_DEMAND_SOURCE_TYPE_NAME VARCHAR2 (80)
Supply Demand Source Type Name
END_PEGGING_ID NUMBER

Pegging id of tree's root
CONSTRAINT_FLAG VARCHAR2 (1)
(Y) Constraining, (N) Not constraining
NUMBER1 NUMBER

Number1
CHAR1 VARCHAR2 (40)
Demand class information
COMPONENT_IDENTIFIER NUMBER

Component id
BATCHABLE_FLAG NUMBER

(1) Batchable, (2) Not batchable
DEST_INV_ITEM_ID NUMBER

Destination item id
SUPPLIER_ATP_DATE DATE

Supplier ATP Date
SUMMARY_FLAG VARCHAR2 (1)
Summary Flag
PTF_DATE DATE

Planning Time Fence Date
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_DATE DATE

Last update date
LAST_UPDATED_BY NUMBER

Last updated by
LAST_UPDATE_LOGIN NUMBER

Last update login
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
ATP_RULE_ID NUMBER

ATP rule id
ALLOCATION_RULE VARCHAR2 (30)
Allocation rule
INFINITE_TIME_FENCE DATE

Infinite time fence
SUBSTITUTION_WINDOW NUMBER

Substitution window
REQUIRED_QUANTITY NUMBER

Required Quantity
ROUNDING_CONTROL NUMBER

(1) Round quantities (2) Do not round
ATP_FLAG VARCHAR2 (1)
ATP flag
ATP_COMPONENT_FLAG VARCHAR2 (1)
ATP components flag
REQUIRED_DATE DATE

Required date
OPERATION_SEQUENCE_ID NUMBER

Operation sequence id
SOURCING_RULE_NAME VARCHAR2 (30)
Sourcing rule name
OFFSET NUMBER

Offset
EFFICIENCY NUMBER

Efficiency
OWNING_DEPARTMENT VARCHAR2 (10)
Owning department id
REVERSE_CUM_YIELD NUMBER

Reverse cumulative yield
BASIS_TYPE NUMBER

Basis type
USAGE NUMBER

Usage
CONSTRAINT_TYPE NUMBER

Constraint type
CONSTRAINT_DATE DATE

Constraint date
CRITICAL_PATH NUMBER

Critical path
PEGGING_TYPE NUMBER

1. Item demand node/org, 2. Item demand node/supplier, etc.
UTILIZATION NUMBER

Utilization percent
ATP_RULE_NAME VARCHAR2 (80)
ATP rule name
PLAN_NAME VARCHAR2 (10)
Plan name
CONSTRAINED_PATH NUMBER

1 if there is a child node flagged as a constraint node in diagnostic atp
PLAN_ID NUMBER

Plan ID
DEMAND_CLASS VARCHAR2 (80)
Demand class
CLASS VARCHAR2 (80)
Customer Class
CUSTOMER_NAME VARCHAR2 (80)
Customer name
CUSTOMER_SITE_NAME VARCHAR2 (80)
Customer site name
ALLOCATED_SUPPLY_QUANTITY NUMBER

Supply allocated to a demand class
SUPPLY_ADJUSTMENT_QUANTITY NUMBER

Supply quantity adjected by stealing
BACKWARD_FORWARD_QUANTITY NUMBER

Quantity after backward/forward consumption
BACKWARD_QUANTITY NUMBER

Quantity after backward consumption
DEMAND_ADJUSTMENT_QUANTITY NUMBER

Quantity adjusted by demand class consumption
ADJUSTED_AVAILABILITY_QUANTITY NUMBER

Net availability after adjustment
ALLOCATION_PERCENT NUMBER

Overall allocation percent
ACTUAL_ALLOCATION_PERCENT NUMBER

Level allocation percent
ADJUSTED_CUM_QUANTITY NUMBER

Cumulative availability after adjustment with unallocated cum
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
BASE_MODEL_ID NUMBER

Source Inventory Item ID for the base model
BASE_MODEL_NAME VARCHAR2 (255)
Name of the base model
MODEL_SD_FLAG NUMBER

Flag to indicate whether the supply is related to model or one of its components or not.
ERROR_CODE NUMBER

Code of the error encountered on the line.
TOTAL_BUCKETED_DEMAND_QUANTITY NUMBER

Total Bucketed demand quantity
AGGREGATE_TIME_FENCE_DATE DATE

Aggregate order promising time fence date
PF_DISPLAY_FLAG NUMBER

Flag to control display of the record in ATP Supply Demand Window
ORIGINAL_DEMAND_DATE DATE

Parent demand's demand date
ORIGINAL_DEMAND_QUANTITY NUMBER

Parent demand's demand quantity
ORIGINAL_ITEM_ID NUMBER

Original supply demand's item identifier
ORIGINAL_SUPPLY_DEMAND_TYPE NUMBER

Parent demand's type of supply/demand
NONATP_FLAG NUMBER

Value 1 indicates that pegging line is for non atpable item
RECEIVING_ORGANIZATION_ID NUMBER

Id of the Receiving organization in case of transfer
UNALLOCATED_QUANTITY NUMBER

Unallocated supply demand quantity
ORIG_CUSTOMER_SITE_NAME VARCHAR2 (255)
Original Customer Site name on demand
ORIG_CUSTOMER_NAME VARCHAR2 (60)
Original Customer name on demand
ORIG_DEMAND_CLASS VARCHAR2 (34)
Original demand class on demand
ORIG_REQUEST_DATE DATE

Original Request Date of Demand Class
ACTUAL_SUPPLY_DEMAND_DATE DATE

Actual Date on which supply/demand is created
SHIPPING_CAL_CODE VARCHAR2 (14)
Stores SHIPPING_CAL_CODE of respective supply pegging line
RECEIVING_CAL_CODE VARCHAR2 (14)
Stores RECEIVING_CAL_CODE of respective supply pegging line
INTRANSIT_CAL_CODE VARCHAR2 (14)
Stores INTRANSIT_CAL_CODE of respective supply pegging line
MANUFACTURING_CAL_CODE VARCHAR2 (14)
Stores MANUFACTURING_CAL_CODE of respective supply pegging line
COMPONENT_YIELD_FACTOR NUMBER

SCALING_TYPE NUMBER

ROUNDING_DIRECTION NUMBER

SCALE_ROUNDING_VARIANCE NUMBER

SCALE_MULTIPLE NUMBER

ORGANIZATION_TYPE NUMBER

Its organization type. 1- discrete, 2-OPM
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 does not reference any database object

MRP.MRP_ATP_DETAILS_TEMP is referenced by following:

SchemaAPPS
SynonymMRP_ATP_DETAILS_TEMP