DBA Data[Home] [Help]

APPS.GMD_LCF_FETCH_PKG dependencies on MTL_ITEM_CATEGORIES

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 808: FROM mtl_item_categories

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
809: WHERE category_id = V_category_id
810: AND inventory_item_id = V_inventory_item_id
811: AND organization_id = V_organization_id;
812: