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

TABLE: MRP.MRP_ATP_SCHEDULE_TEMP

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


MRP_ATP_SCHEDULE_TEMP holds the ATP records that are going to be checked for ATP or demanded. It also holds the summary results of the ATP program. The records in here are only for a single ATP inquiry or demanding process which is identified by the column session_id.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_ATP_SCHEDULE_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnSTATUS_FLAG
MRP_ATP_SCHEDULE_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnORDER_LINE_ID
ColumnSCENARIO_ID
Columns
Name Datatype Length Mandatory Comments
ACTION NUMBER

Type of request. (100) Query, (110) Add demand, (120) Modify demand, etc
CALLING_MODULE NUMBER

Module that called ATP. (724) Planning server, (660) Order Management, etc
SESSION_ID NUMBER
Yes Session identifier
ORDER_HEADER_ID NUMBER

Sales order header
ORDER_LINE_ID NUMBER

Sale order line
INVENTORY_ITEM_ID NUMBER
Yes Item Id
ORGANIZATION_ID NUMBER

Organization ID
SR_INSTANCE_ID NUMBER

Source Instance Id
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
ORDER_NUMBER NUMBER

Order Number
SOURCE_ORGANIZATION_ID NUMBER

Source Organization Id
CUSTOMER_ID NUMBER

Customer Id
CUSTOMER_SITE_ID NUMBER

Customer Site Id
DESTINATION_TIME_ZONE VARCHAR2 (30)
Destination Time Zone (unnused)
QUANTITY_ORDERED NUMBER

Ordered quantity
UOM_CODE VARCHAR2 (3)
Unit Of Measure
REQUESTED_SHIP_DATE DATE

Requested Ship Date
REQUESTED_ARRIVAL_DATE DATE

Requested Arrival Date
LATEST_ACCEPTABLE_DATE DATE

Latest Acceptable Date
DELIVERY_LEAD_TIME NUMBER

Delivery Lead Time
FREIGHT_CARRIER VARCHAR2 (30)
Freight Carrier
SHIP_METHOD VARCHAR2 (30)
Shipping Method
DEMAND_CLASS VARCHAR2 (30)
Demand Class
SHIP_SET_NAME VARCHAR2 (30)
Ship Set Name
SHIP_SET_ID NUMBER

Ship Set Id
ARRIVAL_SET_NAME VARCHAR2 (30)
Arrival Set Name
ARRIVAL_SET_ID NUMBER

Arrival Set Id
OVERRIDE_FLAG VARCHAR2 (1)
ATP Override Flag
SCHEDULED_SHIP_DATE DATE

Scheduled Ship Date
SCHEDULED_ARRIVAL_DATE DATE

Scheduled Arrival Date
AVAILABLE_QUANTITY NUMBER

Quantity available on availability date
REQUESTED_DATE_QUANTITY NUMBER

Quantity available on requested date
GROUP_SHIP_DATE DATE

Group Ship Date of the Set
GROUP_ARRIVAL_DATE DATE

Group arrival date of the set
VENDOR_ID NUMBER

Vendor Id
VENDOR_SITE_ID NUMBER

Vendor Site Id
INSERT_FLAG NUMBER

(1) Insert detailed records, (null or 0) Otherwise
ERROR_CODE VARCHAR2 (240)
Error Code. See MTL_DEMAND_INTERFACE_ERRORS for codes and messages.
ERROR_MESSAGE VARCHAR2 (240)
Error Message
SEQUENCE_NUMBER NUMBER

Sequence Number
FIRM_FLAG NUMBER

(1) Override (2) No override for scheduling
INVENTORY_ITEM_NAME VARCHAR2 (250)
Item Name
SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
Source Organization Code
INSTANCE_ID1 NUMBER

Instance Id of Source Organization
ORDER_LINE_NUMBER NUMBER

Sales Order Line Number
SHIPMENT_NUMBER NUMBER

Shipment Number
OPTION_NUMBER NUMBER

Item for an option or class within a model
PROMISE_DATE DATE

Date promised to user to receive item
CUSTOMER_NAME VARCHAR2 (255)
Customer Name
CUSTOMER_LOCATION VARCHAR2 (40)
Customer Location
OLD_LINE_SCHEDULE_DATE DATE

Old schedule date
OLD_SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
Old source organization
SCENARIO_ID NUMBER
Yes Scenario Id
VENDOR_NAME VARCHAR2 (80)
Vendor Name
VENDOR_SITE_NAME VARCHAR2 (240)
Vendor Site Name
STATUS_FLAG NUMBER

(99) Data transfer
MDI_ROWID VARCHAR2 (30)
Row Id from MTL_DEMAND_INTERFACE
DEMAND_SOURCE_TYPE NUMBER

Demand Source Type
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
Demand Source Delivery
ATP_LEAD_TIME NUMBER

ATP Lead Time
OE_FLAG VARCHAR2 (1)
(Y) not internal sales order (N) internal sales order
ITEM_DESC VARCHAR2 (240)
Item Description
INTRANSIT_LEAD_TIME NUMBER

Intransit Lead Time
SHIP_METHOD_TEXT VARCHAR2 (240)
Ship Method Description
END_PEGGING_ID NUMBER

Root pegging Id of pegging tree
PROJECT_ID NUMBER

Project Id (unused)
TASK_ID NUMBER

Task Id (unused)
PROJECT_NUMBER VARCHAR2 (25)
Project Number (unused)
TASK_NUMBER VARCHAR2 (25)
Task Number (unused)
EXCEPTION1 NUMBER

Exception1
EXCEPTION2 NUMBER

Exception2
EXCEPTION3 NUMBER

Exception3
EXCEPTION4 NUMBER

Exception4
EXCEPTION5 NUMBER

Exception5
EXCEPTION6 NUMBER

Exception6
EXCEPTION7 NUMBER

Exception7
EXCEPTION8 NUMBER

Exception8
EXCEPTION9 NUMBER

Exception9
EXCEPTION10 NUMBER

Exception10
EXCEPTION11 NUMBER

Exception11
EXCEPTION12 NUMBER

Exception12
EXCEPTION13 NUMBER

Exception13
EXCEPTION14 NUMBER

Exception14
EXCEPTION15 NUMBER

Exception15
FIRM_SOURCE_ORG_ID NUMBER

Source organization ID used in override case
FIRM_SOURCE_ORG_CODE VARCHAR2 (7)
Source organization code used in override case
FIRM_SHIP_DATE DATE

Ship date given in override case
FIRM_ARRIVAL_DATE DATE

Arrival date given in override case
OLD_SOURCE_ORGANIZATION_ID NUMBER

Old source organization id
OLD_DEMAND_CLASS VARCHAR2 (30)
Old Demand Class
ATTRIBUTE_06 VARCHAR2 (30)
Attribute_06. Used to hold atp_flag value from the source (MTL_SYSTEM_ITEMS) for an uncollected item.
REQUEST_ITEM_ID NUMBER

Requested item id
REQUEST_ITEM_NAME VARCHAR2 (250)
Requested item name
REQ_ITEM_AVAILABLE_DATE DATE

Requested item available date
REQ_ITEM_AVAILABLE_DATE_QTY NUMBER

Quantity of requested item on availablility date
REQ_ITEM_REQ_DATE_QTY NUMBER

Quantity of requested item on request date
SALES_REP VARCHAR2 (255)
Sales representative on sales order line
CUSTOMER_CONTACT VARCHAR2 (255)
Customer contact on sales order line
SUBST_FLAG NUMBER

(1) If substitution occurred for this line entry
SUBSTITUTION_TYP_CODE NUMBER

(1) All or nothing, (2) Mixed, (3) Refer to item attribute, (4) No substitution
REQ_ITEM_DETAIL_FLAG NUMBER

(1) Provide ATP details for requested item in case of product substitution(2) otherwise
OLD_INVENTORY_ITEM_ID NUMBER

Old item ID
COMPILE_DESIGNATOR VARCHAR2 (10)
Plan Name
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
FLOW_STATUS_CODE VARCHAR2 (30)
Flow status code
ASSIGNMENT_SET_ID NUMBER

Assignment set id: ID of the assignment set to be used by ATP to determine customer based sourcing
DIAGNOSTIC_ATP_FLAG NUMBER

Diagnostic atp flag. 1: Diagnostic ATP Mode, 2: Regular ATP Mode
TOP_MODEL_LINE_ID NUMBER

Line id of the top model.
ATO_PARENT_MODEL_LINE_ID NUMBER

Line Id of the parent ATO Model
ATO_MODEL_LINE_ID NUMBER

Line ID of the Top ATO Model
PARENT_LINE_ID NUMBER

Line ID of the Immidiate Parent
MATCH_ITEM_ID NUMBER

Inventory Item ID of the matched configuration
VALIDATION_ORG NUMBER

ID of the validation org
COMPONENT_SEQUENCE_ID NUMBER

Bill Sequence Id for model
COMPONENT_CODE VARCHAR2 (1000)
Hierarchy of inventory item ids which gives the parnet child relationship in a special format
INCLUDED_ITEM_FLAG NUMBER

Flag which indicates whether included items for PTO models/otion class is passed by calling modules or not. Values 1: Included items are passed. 2: Included items are not passed to ATP
LINE_NUMBER VARCHAR2 (255)
Sales Order Line number on OM sales order pad
BOM_ITEM_TYPE NUMBER

Bom Item Type for the item
CONFIG_ITEM_LINE_ID NUMBER

Line Id of the config item linked to the Sales Order
OSS_ERROR_CODE NUMBER

Error Code for Error Encountered during option specifc sourcing for the line
SOURCE_DOC_ID NUMBER

PO source doc ID in case of internal sales order
PICK_COMPONENTS_FLAG VARCHAR2 (1)
Pick components flag item attribute
MATCHED_ITEM_NAME VARCHAR2 (255)
Name of the matched item
ATP_FLAG VARCHAR2 (1)
ATP Flag
ATP_COMPONENTS_FLAG VARCHAR2 (1)
ATP Components Flag
WIP_SUPPLY_TYPE NUMBER

Wip Supply type
FIXED_LT NUMBER

Fixed Lead time
VARIABLE_LT NUMBER

Variable Lead time
MANDATORY_ITEM_FLAG NUMBER

This flag indicates whether item is included item or not
CASCADE_MODEL_INFO_TO_COMP NUMBER

Flag to indicate whether information for ATO model should be cascaded to its components or not.
ORIGINAL_REQUEST_DATE DATE

request date in 24*7 atp mode
PLAN_ID NUMBER

Plan id for plan against which this line is processed.
INTERNAL_ORG_ID NUMBER

Stores ship_to_org_id in case of internal sales order
FIRST_VALID_SHIP_ARRIVAL_DATE DATE

This column contains first valid shipping or arrival date as per respective calendars
PART_OF_SET VARCHAR2 (1)
This column signifies if the line that is passed to ATP is part of a set that has been already scheduled or not
PARTY_SITE_ID NUMBER

Holds party_site_id
CUSTOMER_COUNTRY VARCHAR2 (60)
Holds Customer_country
CUSTOMER_STATE VARCHAR2 (120)
Holds Customer_state
CUSTOMER_CITY VARCHAR2 (240)
Holds Customer_city
CUSTOMER_POSTAL_CODE VARCHAR2 (60)
Holds Customer_postal_code
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTION
,      CALLING_MODULE
,      SESSION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      ORDER_NUMBER
,      SOURCE_ORGANIZATION_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DESTINATION_TIME_ZONE
,      QUANTITY_ORDERED
,      UOM_CODE
,      REQUESTED_SHIP_DATE
,      REQUESTED_ARRIVAL_DATE
,      LATEST_ACCEPTABLE_DATE
,      DELIVERY_LEAD_TIME
,      FREIGHT_CARRIER
,      SHIP_METHOD
,      DEMAND_CLASS
,      SHIP_SET_NAME
,      SHIP_SET_ID
,      ARRIVAL_SET_NAME
,      ARRIVAL_SET_ID
,      OVERRIDE_FLAG
,      SCHEDULED_SHIP_DATE
,      SCHEDULED_ARRIVAL_DATE
,      AVAILABLE_QUANTITY
,      REQUESTED_DATE_QUANTITY
,      GROUP_SHIP_DATE
,      GROUP_ARRIVAL_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INSERT_FLAG
,      ERROR_CODE
,      ERROR_MESSAGE
,      SEQUENCE_NUMBER
,      FIRM_FLAG
,      INVENTORY_ITEM_NAME
,      SOURCE_ORGANIZATION_CODE
,      INSTANCE_ID1
,      ORDER_LINE_NUMBER
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      PROMISE_DATE
,      CUSTOMER_NAME
,      CUSTOMER_LOCATION
,      OLD_LINE_SCHEDULE_DATE
,      OLD_SOURCE_ORGANIZATION_CODE
,      SCENARIO_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      STATUS_FLAG
,      MDI_ROWID
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_DELIVERY
,      ATP_LEAD_TIME
,      OE_FLAG
,      ITEM_DESC
,      INTRANSIT_LEAD_TIME
,      SHIP_METHOD_TEXT
,      END_PEGGING_ID
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      EXCEPTION1
,      EXCEPTION2
,      EXCEPTION3
,      EXCEPTION4
,      EXCEPTION5
,      EXCEPTION6
,      EXCEPTION7
,      EXCEPTION8
,      EXCEPTION9
,      EXCEPTION10
,      EXCEPTION11
,      EXCEPTION12
,      EXCEPTION13
,      EXCEPTION14
,      EXCEPTION15
,      FIRM_SOURCE_ORG_ID
,      FIRM_SOURCE_ORG_CODE
,      FIRM_SHIP_DATE
,      FIRM_ARRIVAL_DATE
,      OLD_SOURCE_ORGANIZATION_ID
,      OLD_DEMAND_CLASS
,      ATTRIBUTE_06
,      REQUEST_ITEM_ID
,      REQUEST_ITEM_NAME
,      REQ_ITEM_AVAILABLE_DATE
,      REQ_ITEM_AVAILABLE_DATE_QTY
,      REQ_ITEM_REQ_DATE_QTY
,      SALES_REP
,      CUSTOMER_CONTACT
,      SUBST_FLAG
,      SUBSTITUTION_TYP_CODE
,      REQ_ITEM_DETAIL_FLAG
,      OLD_INVENTORY_ITEM_ID
,      COMPILE_DESIGNATOR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FLOW_STATUS_CODE
,      ASSIGNMENT_SET_ID
,      DIAGNOSTIC_ATP_FLAG
,      TOP_MODEL_LINE_ID
,      ATO_PARENT_MODEL_LINE_ID
,      ATO_MODEL_LINE_ID
,      PARENT_LINE_ID
,      MATCH_ITEM_ID
,      VALIDATION_ORG
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      INCLUDED_ITEM_FLAG
,      LINE_NUMBER
,      BOM_ITEM_TYPE
,      CONFIG_ITEM_LINE_ID
,      OSS_ERROR_CODE
,      SOURCE_DOC_ID
,      PICK_COMPONENTS_FLAG
,      MATCHED_ITEM_NAME
,      ATP_FLAG
,      ATP_COMPONENTS_FLAG
,      WIP_SUPPLY_TYPE
,      FIXED_LT
,      VARIABLE_LT
,      MANDATORY_ITEM_FLAG
,      CASCADE_MODEL_INFO_TO_COMP
,      ORIGINAL_REQUEST_DATE
,      PLAN_ID
,      INTERNAL_ORG_ID
,      FIRST_VALID_SHIP_ARRIVAL_DATE
,      PART_OF_SET
,      PARTY_SITE_ID
,      CUSTOMER_COUNTRY
,      CUSTOMER_STATE
,      CUSTOMER_CITY
,      CUSTOMER_POSTAL_CODE
FROM MRP.MRP_ATP_SCHEDULE_TEMP;

Dependencies

[top of page]

MRP.MRP_ATP_SCHEDULE_TEMP does not reference any database object

MRP.MRP_ATP_SCHEDULE_TEMP is referenced by following:

SchemaMRP
ViewMRP_ATP_SCHEDULE_TEMP#