APPS.GML_BATCH_OM_UTIL dependencies on GML_BATCH_SO_RULE_ASSIGNMENTS

Line 452: From gml_batch_so_rule_assignments

448: , decode(item_id, null, 0, item_id) item_id
449: , decode(allocation_class, null, ' ', allocation_class) allocation_class
450: , rule_assign_id
451: , rule_id
452: From gml_batch_so_rule_assignments
453: Where whse_code = p_gme_om_config_assign.whse_code
454: and (item_id = p_gme_om_config_assign.item_id
455: or item_id is null )
456: and (allocation_class = p_gme_om_config_assign.allocation_class

Line 498: From gml_batch_so_rule_assignments

494: , nvl(item_id, 0)
495: , nvl(allocation_class, '0')
496: , nvl(customer_id, 0)
497: , nvl(site_use_id, 0)
498: From gml_batch_so_rule_assignments
499: Where whse_code = p_gme_om_config_assign.whse_code
500: and (item_id = nvl(p_gme_om_config_assign.item_id,0)
501: or item_id is null )
502: and (allocation_class = nvl(p_gme_om_config_assign.allocation_class,'0')

Line 533: From gml_batch_so_rule_assignments

529: Into l_rule_assign_rec.item_id
530: , l_rule_assign_rec.allocation_class
531: , l_rule_assign_rec.customer_id
532: , l_rule_assign_rec.site_use_id
533: From gml_batch_so_rule_assignments
534: Where rule_assign_id = l_rule_assign_id;
535: */
536:
537: /* check the uniqueness

Line 572: 'SELECT count(*) FROM gml_batch_so_rule_assignments WHERE '

568:
569: GMI_reservation_Util.PrintLn('check Rule, to check_rule_assign');
570: GMI_reservation_Util.PrintLn('check Rule,where clause '||l_where_clause);
571: OPEN check_rule_assign for
572: 'SELECT count(*) FROM gml_batch_so_rule_assignments WHERE '
573: || l_where_clause ;
574: Fetch check_rule_assign Into l_rule_count;
575: Close check_rule_assign;
576: