DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on WIP_LINES

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

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

Line 4040: FROM wip_lines wl,

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

Line 4139: IS SELECT START_TIME,MAXIMUM_RATE FROM wip_lines

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

Line 4337: ' FROM wip_lines line, '||

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

Line 4494: ' FROM wip_lines line, '||

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

Line 4698: ' FROM wip_lines line, '||

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

Line 5032: ' FROM wip_lines line, '||

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

Line 5149: FROM wip_lines wl,

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

Line 5224: FROM wip_lines wl,

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

Line 5292: FROM wip_lines wl,

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

Line 5389: FROM wip_lines wl,

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

Line 5458: FROM wip_lines wl,

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

Line 5522: FROM wip_lines wl,

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