DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_SCHEDULE_LINES

Line 756: UPDATE rlm_schedule_lines

752: WHERE header_id = x_header_id
753: AND process_status = rlm_core_sv.k_PS_AVAILABLE
754: AND Item_detail_type = k_MRP_FORECAST;
755: --
756: UPDATE rlm_schedule_lines
757: SET process_status = x_Status
758: WHERE header_id = x_ScheduleHeaderid
759: AND process_status in (rlm_core_sv.k_PS_AVAILABLE,
760: rlm_core_sv.k_PS_ERROR)

Line 765: UPDATE rlm_schedule_lines_all

761: AND item_detail_type = k_MRP_FORECAST;
762: --
763: ELSE
764: --
765: UPDATE rlm_schedule_lines_all
766: SET process_status = x_Status
767: WHERE header_id = x_ScheduleheaderId
768: AND ship_from_org_id = x_Group_rec.ship_from_org_id
769: AND nvl(ship_to_site_use_id,k_NNULL)