APPS.GMD_LCF_FETCH_PKG dependencies on GMD_LCF_CATEGORY_HDR_GTMP

Line 597: FROM gmd_lcf_category_hdr_gtmp a, mtl_item_categories c

593: SELECT b.concatenated_segments, b.inventory_item_id,
594: b.description, b.primary_uom_code
595: FROM mtl_system_items_kfv b
596: WHERE EXISTS (SELECT 1
597: FROM gmd_lcf_category_hdr_gtmp a, mtl_item_categories c
598: WHERE a.category_set_id = c.category_set_id
599: AND a.category_id = c.category_id
600: AND b.organization_id = c.organization_id
601: AND c.organization_id = V_organization_id

Line 773: INSERT INTO GMD_LCF_CATEGORY_HDR_GTMP

769:
770: PROCEDURE load_categories (V_formulation_spec_id IN NUMBER) IS
771: BEGIN
772: IF (V_formulation_spec_id IS NOT NULL) THEN
773: INSERT INTO GMD_LCF_CATEGORY_HDR_GTMP
774: (CATEGORY_ID,CATEGORY_NAME,CATEGORY_SET_ID,
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,

Line 804: FROM gmd_lcf_category_hdr_gtmp;

800: PROCEDURE get_category_value (V_inventory_item_id IN NUMBER, V_organization_id IN NUMBER,
801: V_line_id IN NUMBER) IS
802: CURSOR Cur_check_hdr_category IS
803: SELECT category_id
804: FROM gmd_lcf_category_hdr_gtmp;
805:
806: CURSOR Cur_check_item_category (V_category_id NUMBER) IS
807: SELECT 1
808: FROM mtl_item_categories

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;