[Home] [Help]
3616: MRP_UTIL.MRP_LOG(l_log_message);
3617: RAISE unexpected_error;
3618: END IF;
3619: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3620: ' inventory_item_id from mtl_item_categories mic, '||
3621: ' mtl_categories cat where ' ||
3622: ' cat.category_id = mic.category_id ' ||
3623: ' and mic.organization_id = :cat_organization_id ' ||
3624: ' and mic.category_set_id = :cat_category_set_id ' ||
3626: flm_util.add_bind(':cat_organization_id', p_organization_id);
3627: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3628: ELSIF p_category_set_id IS NOT NULL THEN
3629: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3630: ' inventory_item_id from mtl_item_categories mic '||
3631: ' where mic.organization_id = :cat_organization_id '||
3632: ' and mic.category_set_id = :cat_category_set_id ) ';
3633: flm_util.add_bind(':cat_organization_id', p_organization_id);
3634: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4303: MRP_UTIL.MRP_LOG(l_log_message);
4304: RAISE unexpected_error;
4305: END IF;
4306: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4307: ' inventory_item_id from mtl_item_categories mic, '||
4308: ' mtl_categories cat where ' ||
4309: ' cat.category_id = mic.category_id ' ||
4310: ' and mic.organization_id = :cat_organization_id ' ||
4311: ' and mic.category_set_id = :cat_category_set_id ' ||
4317: l_where_clause := l_where_clause || l_item_where_clause ||
4318: l_cat_where_clause;
4319:
4320: IF p_category_set_id IS NOT NULL THEN
4321: l_cat_table_sql := ' mtl_item_categories mic, ';
4322: l_cat_sql :=
4323: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4324: ' and mic.organization_id = fs.organization_id ' ||
4325: ' and mic.category_set_id = :cat2_category_set_id ';
4457: MRP_UTIL.MRP_LOG(l_log_message);
4458: RAISE unexpected_error;
4459: END IF;
4460: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4461: ' inventory_item_id from mtl_item_categories mic, '||
4462: ' mtl_categories cat where ' ||
4463: ' cat.category_id = mic.category_id ' ||
4464: ' and mic.organization_id = :cat_organization_id ' ||
4465: ' and mic.category_set_id = :cat_category_set_id ' ||
4472: l_cat_where_clause;
4473:
4474: -- Define the select statement
4475: IF p_category_set_id IS NOT NULL THEN
4476: l_cat_table_sql := ' mtl_item_categories mic, ';
4477: l_cat_sql :=
4478: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4479: ' and mic.organization_id = fs.organization_id ' ||
4480: ' and mic.category_set_id = :cat2_category_set_id ';
4640: MRP_UTIL.MRP_LOG(l_log_message);
4641: RAISE unexpected_error;
4642: END IF;
4643: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4644: ' inventory_item_id from mtl_item_categories mic, '||
4645: ' mtl_categories cat where ' ||
4646: ' cat.category_id = mic.category_id ' ||
4647: ' and mic.organization_id = :cat_organization_id ' ||
4648: ' and mic.category_set_id = :cat_category_set_id ' ||
4654: l_where_clause := l_where_clause || l_item_where_clause ||
4655: l_cat_where_clause;
4656:
4657: IF p_category_set_id IS NOT NULL THEN
4658: l_cat_table_sql := ' mtl_item_categories mic, ';
4659: l_cat_sql :=
4660: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4661: ' and mic.organization_id = fs.organization_id ' ||
4662: ' and mic.category_set_id = :cat2_category_set_id ';
4992: MRP_UTIL.MRP_LOG(l_log_message);
4993: RAISE unexpected_error;
4994: END IF;
4995: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4996: ' inventory_item_id from mtl_item_categories mic, '||
4997: ' mtl_categories cat where ' ||
4998: ' cat.category_id = mic.category_id ' ||
4999: ' and mic.organization_id = :cat_organization_id ' ||
5000: ' and mic.category_set_id = :cat_category_set_id ' ||
5012: l_select := ' AND (nvl(fs.planned_quantity,0) - nvl(fs.quantity_completed,0)) <> 0 AND fs.demand_source_header_id IS NULL ';
5013: END IF;
5014:
5015: IF p_category_set_id IS NOT NULL THEN
5016: l_cat_table_sql := ' mtl_item_categories mic, ';
5017: l_cat_sql :=
5018: ' and mic.inventory_item_id = fs.primary_item_id ' ||
5019: ' and mic.organization_id = fs.organization_id ' ||
5020: ' and mic.category_set_id = :cat2_category_set_id ';
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
5155: AND fs1.demand_source_header_id IS NULL
5156: -- AND nvl(fs1.closed,0) = 0
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
5230: -- AND nvl(fs1.closed,0) = 0
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
5395: AND wl.organization_id = fs1.organization_id
5396: AND wl.line_code
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
5464: AND wl.line_code