DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_SCHEDULE_LINES

Line 773: UPDATE rlm_schedule_lines

769: WHERE header_id = x_header_id
770: AND process_status = rlm_core_sv.k_PS_AVAILABLE
771: AND Item_detail_type = k_MRP_FORECAST;
772: --
773: UPDATE rlm_schedule_lines
774: SET process_status = x_Status
775: WHERE header_id = x_ScheduleHeaderid
776: AND process_status in (rlm_core_sv.k_PS_AVAILABLE,
777: rlm_core_sv.k_PS_ERROR)

Line 782: UPDATE rlm_schedule_lines_all

778: AND item_detail_type = k_MRP_FORECAST;
779: --
780: ELSE
781: --
782: UPDATE rlm_schedule_lines_all
783: SET process_status = x_Status
784: WHERE header_id = x_ScheduleheaderId
785: AND ship_from_org_id = x_Group_rec.ship_from_org_id
786: AND nvl(ship_to_site_use_id,k_NNULL)