DBA Data[Home] [Help]

APPS.MSC_X_REPLENISH dependencies on MSC_PLAN_ORG_STATUS

Line 265: from msc_plan_org_status

261: -- last netting run
262:
263: select status
264: into l_last_max_refresh_number
265: from msc_plan_org_status
266: where plan_id = -1
267: and organization_id = -1
268: and sr_instance_id = -1;
269:

Line 274: insert into msc_plan_org_status (plan_id,

270: exception
271: when no_data_found then
272: l_last_max_refresh_number := 0;
273:
274: insert into msc_plan_org_status (plan_id,
275: organization_id,
276: sr_instance_id,
277: status,
278: status_date

Line 419: update msc_plan_org_status

415: );
416:
417: print_user_info('End of VMI exception engine');
418:
419: update msc_plan_org_status
420: set status = l_curr_max_refresh_number,
421: status_date = sysdate
422: , number1 = p_supplier_time_fence
423: where plan_id = -1