APPS.GMD_LCF_FETCH_PKG dependencies on GMD_COMPOSITIONAL_REQS

Line 779: FROM mtl_category_sets mcs, mtl_categories_kfv mc, gmd_compositional_reqs gcr

775: CATEGORY_SET_NAME,MIN_PCT,MAX_PCT)
776: SELECT gcr.category_id,mc.concatenated_segments,
777: gcr.category_set_id,mcs.category_set_name,
778: gcr.min_pct,gcr.max_pct
779: FROM mtl_category_sets mcs, mtl_categories_kfv mc, gmd_compositional_reqs gcr
780: WHERE mcs.category_set_id = gcr.category_set_id
781: AND mc.category_id = gcr.category_id
782: AND gcr.formulation_spec_id = V_formulation_spec_id
783: ORDER BY order_no;

Line 951: FROM gmd_compositional_reqs a, gmd_lcf_category_hdr_gtmp b

947:
948: --Get the compositional requirements defined for particular formulation specification.
949: CURSOR Cur_get_comp_req (V_formulation_spec_id NUMBER) IS
950: SELECT a.category_id, a.min_pct, a.max_pct, b.category_name
951: FROM gmd_compositional_reqs a, gmd_lcf_category_hdr_gtmp b
952: WHERE a.category_id = b.category_id
953: AND (a.min_pct IS NOT NULL OR a.max_pct IS NOT NULL)
954: AND a.formulation_spec_id = V_formulation_spec_id
955: ORDER BY order_no;