DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on WIP_LINES

Line 3576: l_where_clause := ' and wfs.line_id in (select line_id from wip_lines '||

3572: flm_util.init_bind;
3573:
3574: -- Construct where clause
3575: IF p_from_line IS NOT NULL and p_to_line IS NOT NULL THEN
3576: l_where_clause := ' and wfs.line_id in (select line_id from wip_lines '||
3577: ' where line_code between :from_line and :to_line )';
3578: flm_util.add_bind(':from_line', p_from_line);
3579: flm_util.add_bind(':to_line', p_to_line);
3580: END IF;

Line 4043: FROM wip_lines wl,

4039: date2,
4040: nvl(number6,0),
4041: number7,
4042: number7 - nvl(number6,0)
4043: FROM wip_lines wl,
4044: mtl_system_items_kfv kfv,
4045: wip_schedule_groups sg,
4046: mrp_form_query
4047: WHERE wl.line_id = number1

Line 4142: IS SELECT START_TIME,MAXIMUM_RATE FROM wip_lines

4138: AND scheduled_completion_date >= flm_timezone.client00_in_server(p_scheduled_completion_date) --fix bug#3170105
4139: AND scheduled_completion_date < flm_timezone.client00_in_server(p_scheduled_completion_date+1); --fix bug#3170105
4140:
4141: CURSOR Line_Details(p_line_id NUMBER)
4142: IS SELECT START_TIME,MAXIMUM_RATE FROM wip_lines
4143: WHERE organization_id = p_organization_id
4144: AND LINE_ID = p_line_id;
4145:
4146: CURSOR Check_Last_Schedule

Line 4340: ' FROM wip_lines line, '||

4336: -- Define the select statement
4337: --fix bug#3170105
4338: l_sql_stmt :=
4339: 'SELECT fs.wip_entity_id ' ||
4340: ' FROM wip_lines line, '||
4341: l_cat_table_sql ||
4342: ' mtl_system_items_kfv msi, '||
4343: ' wip_flow_schedules fs ' ||
4344: ' WHERE fs.organization_id = to_char( :organization_id) ' ||

Line 4497: ' FROM wip_lines line, '||

4493: ' SELECT fs.line_id, line.line_code, fs.primary_item_id, ' ||
4494: ' msi.concatenated_segments,null' ||
4495: ' ,sum(nvl(fs.planned_quantity,0)), ' ||
4496: ' sum(nvl(fs.quantity_completed,0)) ' ||
4497: ' FROM wip_lines line, '||
4498: l_cat_table_sql ||
4499: ' mtl_system_items_kfv msi, '||
4500: ' wip_flow_schedules fs ' ||
4501: ' WHERE fs.organization_id = to_char( :organization_id ) ' ||

Line 4701: ' FROM wip_lines line, '||

4697: ' fs.ATTRIBUTE12, fs.ATTRIBUTE13,fs.ATTRIBUTE14, '||
4698: ' fs.ATTRIBUTE15, fs.KANBAN_CARD_ID,fs.END_ITEM_UNIT_NUMBER, '||
4699: ' fs.CURRENT_LINE_OPERATION, '||
4700: ' fs.WIP_ENTITY_ID '||
4701: ' FROM wip_lines line, '||
4702: l_cat_table_sql ||
4703: ' mtl_system_items_kfv msi, '||
4704: ' wip_flow_schedules fs ' ||
4705: ' WHERE fs.organization_id = to_char(:organization_id) '||

Line 5035: ' FROM wip_lines line, '||

5031: -- Define the select statement
5032: --fix bug#3170105
5033: l_sql_stmt :=
5034: ' SELECT fs.wip_entity_id ' ||
5035: ' FROM wip_lines line, '||
5036: l_cat_table_sql ||
5037: ' mtl_system_items_kfv msi, '||
5038: ' wip_flow_schedules fs ' ||
5039: ' WHERE fs.organization_id = to_char(:organization_id) ' ||

Line 5152: FROM wip_lines wl,

5148: +floor(p_to_start_date-p_from_start_date),
5149: NULL,
5150: 0,
5151: fs1.organization_id
5152: FROM wip_lines wl,
5153: mtl_system_items_kfv kfv,
5154: mtl_categories_kfv cat,
5155: mtl_item_categories mic,
5156: wip_flow_schedules fs1

Line 5227: FROM wip_lines wl,

5223: +floor(p_to_start_date-p_from_start_date),
5224: NULL,
5225: 0,
5226: fs1.organization_id
5227: FROM wip_lines wl,
5228: mtl_system_items_kfv kfv,
5229: mtl_item_categories mic,
5230: wip_flow_schedules fs1
5231: WHERE wl.line_id = fs1.line_id

Line 5295: FROM wip_lines wl,

5291: +floor(p_to_start_date-p_from_start_date),
5292: NULL,
5293: 0,
5294: fs1.organization_id
5295: FROM wip_lines wl,
5296: mtl_system_items_kfv kfv,
5297: wip_flow_schedules fs1
5298: WHERE wl.line_id = fs1.line_id
5299: AND fs1.demand_source_header_id IS NULL

Line 5392: FROM wip_lines wl,

5388: NULL,
5389: 0,
5390: fs1.organization_id,
5391: NVL(fs1.build_sequence,0)
5392: FROM wip_lines wl,
5393: mtl_system_items_kfv kfv,
5394: mtl_categories_kfv cat,
5395: mtl_item_categories mic,
5396: wip_flow_schedules fs1

Line 5461: FROM wip_lines wl,

5457: NULL,
5458: 0,
5459: fs1.organization_id,
5460: NVL(fs1.build_sequence,0)
5461: FROM wip_lines wl,
5462: mtl_system_items_kfv kfv,
5463: mtl_item_categories mic,
5464: wip_flow_schedules fs1
5465: WHERE wl.line_id = fs1.line_id

Line 5525: FROM wip_lines wl,

5521: NULL,
5522: 0,
5523: fs1.organization_id,
5524: NVL(fs1.build_sequence,0)
5525: FROM wip_lines wl,
5526: mtl_system_items_kfv kfv,
5527: wip_flow_schedules fs1
5528: WHERE wl.line_id = fs1.line_id
5529: AND wl.organization_id = fs1.organization_id