[Home] [Help]
3619: MRP_UTIL.MRP_LOG(l_log_message);
3620: RAISE unexpected_error;
3621: END IF;
3622: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3623: ' inventory_item_id from mtl_item_categories mic, '||
3624: ' mtl_categories cat where ' ||
3625: ' cat.category_id = mic.category_id ' ||
3626: ' and mic.organization_id = :cat_organization_id ' ||
3627: ' and mic.category_set_id = :cat_category_set_id ' ||
3629: flm_util.add_bind(':cat_organization_id', p_organization_id);
3630: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
3631: ELSIF p_category_set_id IS NOT NULL THEN
3632: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3633: ' inventory_item_id from mtl_item_categories mic '||
3634: ' where mic.organization_id = :cat_organization_id '||
3635: ' and mic.category_set_id = :cat_category_set_id ) ';
3636: flm_util.add_bind(':cat_organization_id', p_organization_id);
3637: flm_util.add_bind(':cat_category_set_id', p_category_set_id);
4306: MRP_UTIL.MRP_LOG(l_log_message);
4307: RAISE unexpected_error;
4308: END IF;
4309: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4310: ' inventory_item_id from mtl_item_categories mic, '||
4311: ' mtl_categories cat where ' ||
4312: ' cat.category_id = mic.category_id ' ||
4313: ' and mic.organization_id = :cat_organization_id ' ||
4314: ' and mic.category_set_id = :cat_category_set_id ' ||
4320: l_where_clause := l_where_clause || l_item_where_clause ||
4321: l_cat_where_clause;
4322:
4323: IF p_category_set_id IS NOT NULL THEN
4324: l_cat_table_sql := ' mtl_item_categories mic, ';
4325: l_cat_sql :=
4326: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4327: ' and mic.organization_id = fs.organization_id ' ||
4328: ' and mic.category_set_id = :cat2_category_set_id ';
4460: MRP_UTIL.MRP_LOG(l_log_message);
4461: RAISE unexpected_error;
4462: END IF;
4463: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4464: ' inventory_item_id from mtl_item_categories mic, '||
4465: ' mtl_categories cat where ' ||
4466: ' cat.category_id = mic.category_id ' ||
4467: ' and mic.organization_id = :cat_organization_id ' ||
4468: ' and mic.category_set_id = :cat_category_set_id ' ||
4475: l_cat_where_clause;
4476:
4477: -- Define the select statement
4478: IF p_category_set_id IS NOT NULL THEN
4479: l_cat_table_sql := ' mtl_item_categories mic, ';
4480: l_cat_sql :=
4481: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4482: ' and mic.organization_id = fs.organization_id ' ||
4483: ' and mic.category_set_id = :cat2_category_set_id ';
4643: MRP_UTIL.MRP_LOG(l_log_message);
4644: RAISE unexpected_error;
4645: END IF;
4646: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4647: ' inventory_item_id from mtl_item_categories mic, '||
4648: ' mtl_categories cat where ' ||
4649: ' cat.category_id = mic.category_id ' ||
4650: ' and mic.organization_id = :cat_organization_id ' ||
4651: ' and mic.category_set_id = :cat_category_set_id ' ||
4657: l_where_clause := l_where_clause || l_item_where_clause ||
4658: l_cat_where_clause;
4659:
4660: IF p_category_set_id IS NOT NULL THEN
4661: l_cat_table_sql := ' mtl_item_categories mic, ';
4662: l_cat_sql :=
4663: ' and mic.inventory_item_id = fs.primary_item_id ' ||
4664: ' and mic.organization_id = fs.organization_id ' ||
4665: ' and mic.category_set_id = :cat2_category_set_id ';
4995: MRP_UTIL.MRP_LOG(l_log_message);
4996: RAISE unexpected_error;
4997: END IF;
4998: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4999: ' inventory_item_id from mtl_item_categories mic, '||
5000: ' mtl_categories cat where ' ||
5001: ' cat.category_id = mic.category_id ' ||
5002: ' and mic.organization_id = :cat_organization_id ' ||
5003: ' and mic.category_set_id = :cat_category_set_id ' ||
5015: l_select := ' AND (nvl(fs.planned_quantity,0) - nvl(fs.quantity_completed,0)) <> 0 AND fs.demand_source_header_id IS NULL ';
5016: END IF;
5017:
5018: IF p_category_set_id IS NOT NULL THEN
5019: l_cat_table_sql := ' mtl_item_categories mic, ';
5020: l_cat_sql :=
5021: ' and mic.inventory_item_id = fs.primary_item_id ' ||
5022: ' and mic.organization_id = fs.organization_id ' ||
5023: ' and mic.category_set_id = :cat2_category_set_id ';
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
5158: AND fs1.demand_source_header_id IS NULL
5159: -- AND nvl(fs1.closed,0) = 0
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
5233: -- AND nvl(fs1.closed,0) = 0
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
5398: AND wl.organization_id = fs1.organization_id
5399: AND wl.line_code
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
5467: AND wl.line_code