APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3051: FROM mtl_system_items_kfv

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

Line 4044: mtl_system_items_kfv kfv,

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

Line 4342: ' mtl_system_items_kfv msi, '||

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

Line 4499: ' mtl_system_items_kfv msi, '||

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

Line 4703: ' mtl_system_items_kfv msi, '||

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

Line 5037: ' mtl_system_items_kfv msi, '||

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) ' ||
5040: l_where_clause ||
5041: l_select ||

Line 5153: mtl_system_items_kfv kfv,

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

Line 5228: mtl_system_items_kfv kfv,

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

Line 5296: mtl_system_items_kfv kfv,

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

Line 5393: mtl_system_items_kfv kfv,

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

Line 5462: mtl_system_items_kfv kfv,

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

Line 5526: mtl_system_items_kfv kfv,

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