DBA Data[Home] [Help]

APPS.MRP_GRAPH_LINE_CAPACITY dependencies on WIP_LINES

Line 159: FROM wip_lines

155:
156: -- Fix bug 939061, add 24 hrs to stop_time if stop_time <= start_time
157: CURSOR LINE_CURSOR IS
158: SELECT NVL(maximum_rate * ((decode(least(stop_time,start_time),stop_time,stop_time+24*3600,stop_time)-start_time)/3600),0)
159: FROM wip_lines
160: WHERE line_id = p_line_id
161: AND organization_id = p_org_id;
162:
163: l_last_dept_id NUMBER := -5;