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_UNDO dependencies on MSC_SHIPMENTS

Line 627: delete from msc_shipments

623: Delete from msc_plans
624: where plan_id = p_plan_id ;
625: elsif ( p_table_changed = 7 ) then
626: -- Trips
627: delete from msc_shipments
628: where plan_id = p_plan_id
629: and sr_instance_id = l_sr_instance_id
630: and shipment_id = l_transaction_id;
631: end if;

Line 831: update_str := 'UPDATE MSC_SHIPMENTS SET STATUS=0, APPLIED=2, ';

827: Execute immediate sql_string
828: using p_old_value, p_plan_id,
829: p_sr_instance_id,p_transaction_id ;
830: elsif (p_table_changed = 7) then
831: update_str := 'UPDATE MSC_SHIPMENTS SET STATUS=0, APPLIED=2, ';
832: if (p_column_type = 'DATE') then
833: set_str := p_column_changed
834: ||' = fnd_date.canonical_to_date(:p_old_value) ';
835: else