eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_DEMANDS

Line 550: update msc_demands

546: END update_sup_rel_error;
547:
548: Procedure update_dmd_rel_error IS
549: BEGIN
550: update msc_demands
551: set release_errors = p_rel_error,
552: implement_org_id = null,
553: implement_instance_id = null,
554: implement_date = NULL,

Line 577: update msc_demands

573: BEGIN
574: msc_rel_wf.update_so_dates(p_plan_id, p_transaction_id, p_inst_id,
575: p_impl_date, v_ship_date, v_arrival_date,
576: v_earliest_date);
577: update msc_demands
578: set implement_org_id = organization_id,
579: implement_instance_id = sr_instance_id,
580: implement_date = nvl(implement_date,planned_ship_date),
581: implement_ship_date = v_ship_date,

Line 711: ' and source_table = ''MSC_DEMANDS'''||

707: 'from msc_orders_v mo' ||
708: ' where ' || p_where_clause ||
709: ' and nvl(release_status,2) = 2' ||
710: ' and order_type = 30'||
711: ' and source_table = ''MSC_DEMANDS'''||
712: ' and exists (select 1 from msc_exception_details med ' ||
713: ' where med.plan_id = mo.plan_id ' ||
714: ' and med.exception_type = 70 ' ||
715: ' and med.organization_id = mo.organization_id '||