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

VIEW: APPS.MRP_ATP_SCHEDULE_TEMP_V

Object Details
Object Name: MRP_ATP_SCHEDULE_TEMP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ATP_SCHEDULE_TEMP_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION NUMBER

Action can be ATP call or Schedule an order
CALLING_MODULE NUMBER

ATP can be called either from the source or from the server
ROW_ID ROWID (10)
SESSION_ID NUMBER
Yes ATP session identifier
ORDER_HEADER_ID NUMBER

Sales Order Header Identifier
ORDER_NUMBER NUMBER

Sales Order Number
ORDER_LINE_ID NUMBER

Sales Order Line Identifier
INVENTORY_ITEM_ID NUMBER
Yes Item Identifier
ORGANIZATION_ID NUMBER

Org Identifier
SR_INSTANCE_ID NUMBER

Instance Identifier
ORGANIZATION_CODE VARCHAR2 (7)
Org Name
SOURCE_ORGANIZATION_ID NUMBER

Source Org Identifier
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
DESTINATION_TIME_ZONE VARCHAR2 (30)
Time zone of the destination
QUANTITY_ORDERED NUMBER

Qty ordered
UOM_CODE VARCHAR2 (3)
Unit of Measure code
REQUESTED_SHIP_DATE DATE

Request ship date
REQUESTED_ARRIVAL_DATE DATE

Request 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)
Ship Method
DEMAND_CLASS VARCHAR2 (30)
Demand Class
SHIP_SET_NAME VARCHAR2 (30)
Ship Set name
ARRIVAL_SET_NAME VARCHAR2 (30)
Arrival Set Name
OVERRIDE_FLAG VARCHAR2 (1)
Override Flag
SCHEDULED_SHIP_DATE DATE

Scheduled Ship Date
SCHEDULED_ARRIVAL_DATE DATE

Scheduled Arrival Date
AVAILABLE_QUANTITY NUMBER

Available Quantity
REQUESTED_DATE_QUANTITY NUMBER

Requested Date Quantity
GROUP_SHIP_DATE DATE

Group Ship Date
GROUP_ARRIVAL_DATE DATE

Group Arrival Date
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_SITE_ID NUMBER

INSERT_FLAG NUMBER

Insert Flag
ERROR_CODE VARCHAR2 (240)
Error Code
ERROR_MESSAGE VARCHAR2 (80)
Error Message
SEQUENCE_NUMBER NUMBER

Line sequence number
FIRM_FLAG NUMBER

Firm flag
INVENTORY_ITEM_NAME VARCHAR2 (250)
Item name
SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
Source Org Name
INSTANCE_ID1 NUMBER

Instance Identifier
ORDER_LINE_NUMBER NUMBER

Order Line Number
PROMISE_DATE DATE

Promise Date
CUSTOMER_NAME VARCHAR2 (255)
Customer name
CUSTOMER_LOCATION VARCHAR2 (40)
Customer Location
OLD_LINE_SCHEDULE_DATE DATE

Old Scheduled Date on Sales Order
OLD_SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
Old Source Org Name
SCENARIO_ID NUMBER
Yes Scenario Identifier
VENDOR_NAME VARCHAR2 (80)
Vendore Name
VENDOR_SITE_NAME VARCHAR2 (240)
Vendor Site Name
STATUS_FLAG NUMBER

Status Flag
SCHEDULE_STATUS_CODE VARCHAR2 (30)
ITEM_DESC VARCHAR2 (240)
Description of the item
INTRANSIT_LEAD_TIME NUMBER

Instransit Lead Time
SHIP_METHOD_TEXT VARCHAR2 (240)
Ship Method text
END_PEGGING_ID NUMBER

End Pegging Identifier
SHIPMENT_NUMBER NUMBER

Shipment Number
OPTION_NUMBER NUMBER

Option Number
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Task Identifier
SHIP_SET_ID NUMBER

Ship Set Identifier
ARRIVAL_SET_ID NUMBER

Arrival Set Identifier
PROJECT_NUMBER VARCHAR2 (25)
Project Number
TASK_NUMBER VARCHAR2 (25)
EXCEPTION1 NUMBER

Exception
EXCEPTION2 NUMBER

Exception
EXCEPTION3 NUMBER

Exception
EXCEPTION4 NUMBER

Exception
EXCEPTION5 NUMBER

Exception
EXCEPTION6 NUMBER

Exception
EXCEPTION7 NUMBER

Exception
EXCEPTION8 NUMBER

Exception
EXCEPTION9 NUMBER

Exception
EXCEPTION10 NUMBER

Exception
EXCEPTION11 NUMBER

Exception
EXCEPTION12 NUMBER

Exception
EXCEPTION13 NUMBER

Exception
EXCEPTION14 NUMBER

Exception
EXCEPTION15 NUMBER

Exception
FIRM_SOURCE_ORG_ID NUMBER

Firm Source Org
FIRM_SOURCE_ORG_CODE VARCHAR2 (7)
Firm Source Org Code
FIRM_SHIP_DATE DATE

Firm Ship Date
FIRM_ARRIVAL_DATE DATE

Firm Arrival Date
REQUEST_ITEM_NAME VARCHAR2 (250)
Request Item Name
REQ_ITEM_AVAILABLE_DATE DATE

Request Item Available Date
REQ_ITEM_AVAILABLE_DATE_QTY NUMBER

REQ_ITEM_REQ_DATE_QTY NUMBER

Available Qty on Request Date
COMPILE_DESIGNATOR VARCHAR2 (10)
FLOW_STATUS_CODE VARCHAR2 (30)
Status
MATCHED_ITEM_NAME VARCHAR2 (255)
LINE_NUMBER VARCHAR2 (255)
ATO_LINE_ID NUMBER

ATP_ITEM_TYPE NUMBER

DAYS_LATE NUMBER

Query Text

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


SELECT ACTION
,      CALLING_MODULE
,      ROW_ID
,      SESSION_ID
,      ORDER_HEADER_ID
,      ORDER_NUMBER
,      ORDER_LINE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      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
,      ARRIVAL_SET_NAME
,      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
,      PROMISE_DATE
,      CUSTOMER_NAME
,      CUSTOMER_LOCATION
,      OLD_LINE_SCHEDULE_DATE
,      OLD_SOURCE_ORGANIZATION_CODE
,      SCENARIO_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      STATUS_FLAG
,      SCHEDULE_STATUS_CODE
,      ITEM_DESC
,      INTRANSIT_LEAD_TIME
,      SHIP_METHOD_TEXT
,      END_PEGGING_ID
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      PROJECT_ID
,      TASK_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_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
,      REQUEST_ITEM_NAME
,      REQ_ITEM_AVAILABLE_DATE
,      REQ_ITEM_AVAILABLE_DATE_QTY
,      REQ_ITEM_REQ_DATE_QTY
,      COMPILE_DESIGNATOR
,      FLOW_STATUS_CODE
,      MATCHED_ITEM_NAME
,      LINE_NUMBER
,      ATO_LINE_ID
,      ATP_ITEM_TYPE
,      DAYS_LATE
FROM APPS.MRP_ATP_SCHEDULE_TEMP_V;

Dependencies

[top of page]

APPS.MRP_ATP_SCHEDULE_TEMP_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_ATP_SCHEDULE_TEMP
SynonymOE_ORDER_LINES_ALL

APPS.MRP_ATP_SCHEDULE_TEMP_V is not referenced by any database object