APPS.MRP_MANAGER_PK dependencies on MRP_SCHEDULE_DATES

Line 2076: UPDATE mrp_schedule_dates dates

2072: | For line reference, copy only if for the same org |
2073: | Do not copy end_item_unit_number because it is not stored on forecast |
2074: +-----------------------------------------------------------------------*/
2075:
2076: UPDATE mrp_schedule_dates dates
2077: SET (schedule_comments, line_id, project_id, task_id)
2078: = (SELECT fc_dates.comments,
2079: DECODE(fc_dates.organization_id,
2080: dates.organization_id, fc_dates.line_id, NULL),

Line 2110: UPDATE mrp_schedule_dates dates

2106: | copy only project reference for sales order to schedule load |
2107: | copy end_item_unit_number |
2108: +-------------------------------------------------------------*/
2109:
2110: UPDATE mrp_schedule_dates dates
2111: SET (project_id, task_id, end_item_unit_number)
2112: = (SELECT DECODE(mtl.project_reference_enabled,
2113: 1, mrp_manager_pk.get_project_id(dates.reservation_id),
2114: NULL),

Line 2143: UPDATE mrp_schedule_dates dates1

2139: | Desc flex: only MDS -> MDS or MPS -> MPS |
2140: | Line reference: copy only if for the same org |
2141: +-----------------------------------------------------------------------*/
2142:
2143: UPDATE mrp_schedule_dates dates1
2144: SET (ddf_context, attribute_category,
2145: attribute1, attribute2, attribute3,
2146: attribute4, attribute5, attribute6,
2147: attribute7, attribute8, attribute9,

Line 2200: mrp_schedule_dates dates2

2196: dates2.end_item_unit_number
2197: FROM mtl_parameters mtl,
2198: mrp_schedule_designators sched1,
2199: mrp_schedule_designators sched2,
2200: mrp_schedule_dates dates2
2201: WHERE dates2.mps_transaction_id = dates1.old_transaction_id
2202: AND dates2.schedule_level = dates1.schedule_level
2203: AND sched1.organization_id = dates1.organization_id
2204: AND sched1.schedule_designator = dates1.schedule_designator

Line 2226: UPDATE mrp_schedule_dates dates

2222: | Do not copy line reference since they're always for different orgs |
2223: | copy end_item_unit_number |
2224: +------------------------------------------------------------------------*/
2225:
2226: UPDATE mrp_schedule_dates dates
2227: SET (project_id, task_id, end_item_unit_number)
2228: = (SELECT DECODE(mtl.project_reference_enabled,
2229: 1, recom.project_id,
2230: NULL),

Line 2249: UPDATE mrp_schedule_dates

2245: arg_row_count := arg_row_count + SQL%ROWCOUNT;
2246:
2247: end if;
2248:
2249: UPDATE mrp_schedule_dates
2250: SET to_update = null
2251: WHERE old_transaction_id >= 0;
2252:
2253: EXCEPTION