APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3048: FROM mtl_system_items_kfv

3044: l_item_segments VARCHAR2(2000);
3045:
3046: CURSOR ITEM_SEGMENTS IS
3047: SELECT concatenated_segments
3048: FROM mtl_system_items_kfv
3049: WHERE inventory_item_id = p_item_id
3050: AND organization_id = p_org_id;
3051:
3052: BEGIN

Line 4041: mtl_system_items_kfv kfv,

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
4045: AND wl.organization_id = number10

Line 4339: ' mtl_system_items_kfv msi, '||

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) ' ||
4342: l_where_clause ||
4343: ' AND fs.scheduled_completion_date < flm_timezone.sysdate00_in_server' ||

Line 4496: ' mtl_system_items_kfv msi, '||

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 ) ' ||
4499: l_where_clause ||
4500: ' AND (nvl(fs.planned_quantity,0) - nvl(fs.quantity_completed,0)) <> 0 ' ||

Line 4700: ' mtl_system_items_kfv msi, '||

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) '||
4703: l_where_clause ||
4704: ' AND (nvl(fs.planned_quantity,0) - nvl(fs.quantity_completed,0)) > 0 ' ||

Line 5034: ' mtl_system_items_kfv msi, '||

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) ' ||
5037: l_where_clause ||
5038: l_select ||

Line 5150: mtl_system_items_kfv kfv,

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
5154: WHERE wl.line_id = fs1.line_id

Line 5225: mtl_system_items_kfv kfv,

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
5229: AND fs1.demand_source_header_id IS NULL

Line 5293: mtl_system_items_kfv kfv,

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
5297: -- AND nvl(fs1.closed,0) = 0

Line 5390: mtl_system_items_kfv kfv,

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
5394: WHERE wl.line_id = fs1.line_id

Line 5459: mtl_system_items_kfv kfv,

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
5463: AND wl.organization_id = fs1.organization_id

Line 5523: mtl_system_items_kfv kfv,

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
5527: AND wl.line_code