DBA Data[Home] [Help]

APPS.MSC_ATPUI_UTIL dependencies on MRP_ATP_SCHEDULE_TEMP

Line 10: INSERT INTO MRP_ATP_SCHEDULE_TEMP

6: p_return_status out nocopy VARCHAR2,
7: p_error_message out nocopy VARCHAR2) IS
8: BEGIN
9: FORALL lCounter IN 1 .. p_atp_schedule_temp.ACTION.COUNT
10: INSERT INTO MRP_ATP_SCHEDULE_TEMP
11: ( ACTION, CALLING_MODULE, SESSION_ID, ORDER_HEADER_ID, ORDER_LINE_ID,
12: INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, ORGANIZATION_CODE, ORDER_NUMBER,
13: 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,
14: FREIGHT_CARRIER, SHIP_METHOD, DEMAND_CLASS, SHIP_SET_NAME, ARRIVAL_SET_NAME,

Line 191: FROM MRP_ATP_SCHEDULE_TEMP

187: p_atp_schedule_temp.CREATED_BY ,p_atp_schedule_temp.LAST_UPDATE_DATE,
188: p_atp_schedule_temp.LAST_UPDATED_BY ,p_atp_schedule_temp.LAST_UPDATE_LOGIN ,
189: p_atp_schedule_temp.FLOW_STATUS_CODE ,p_atp_schedule_temp.ASSIGNMENT_SET_ID,
190: p_atp_schedule_temp.DIAGNOSTIC_ATP_FLAG
191: FROM MRP_ATP_SCHEDULE_TEMP
192: WHERE session_id = p_session_id and status_flag=2;
193:
194: get_details_temp_rows( p_atp_details_temp,
195: p_session_id ,