APPS.MRP_MANAGER_PK dependencies on MRP_SCHEDULE_DATES

Line 2081: UPDATE mrp_schedule_dates dates

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

Line 2115: UPDATE mrp_schedule_dates dates

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

Line 2148: UPDATE mrp_schedule_dates dates1

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

Line 2205: mrp_schedule_dates dates2

2201: dates2.end_item_unit_number
2202: FROM mtl_parameters mtl,
2203: mrp_schedule_designators sched1,
2204: mrp_schedule_designators sched2,
2205: mrp_schedule_dates dates2
2206: WHERE dates2.mps_transaction_id = dates1.old_transaction_id
2207: AND dates2.schedule_level = dates1.schedule_level
2208: AND sched1.organization_id = dates1.organization_id
2209: AND sched1.schedule_designator = dates1.schedule_designator

Line 2231: UPDATE mrp_schedule_dates dates

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

Line 2254: UPDATE mrp_schedule_dates

2250: arg_row_count := arg_row_count + SQL%ROWCOUNT;
2251:
2252: end if;
2253:
2254: UPDATE mrp_schedule_dates
2255: SET to_update = null
2256: WHERE old_transaction_id >= 0;
2257:
2258: EXCEPTION