APPS.GMD_API_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1707: FROM mtl_system_items_kfv

1703: LocalCheckRecord c_check_recipe%ROWTYPE;
1704:
1705: CURSOR c_get_item(l_item_id NUMBER) IS
1706: SELECT description item_desc1, concatenated_segments item_no
1707: FROM mtl_system_items_kfv
1708: WHERE inventory_item_id = l_item_id;
1709: LocalItemRecord c_get_item%ROWTYPE;
1710:
1711: -- Local Variables

Line 1929: FROM fm_matl_dtl d, mtl_system_items_kfv b

1925: WHERE formula_id = p_formula_id;
1926:
1927: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1928: SELECT d.revision, b.concatenated_segments
1929: FROM fm_matl_dtl d, mtl_system_items_kfv b
1930: WHERE formula_id = p_formula_id
1931: AND b.inventory_item_id = d.inventory_item_id
1932: AND b.organization_id = V_organization_id
1933: AND revision IS NOT NULL

Line 1974: FROM mtl_system_items_kfv

1970:
1971:
1972: CURSOR Cur_get_item_no (V_inventory_item_id NUMBER) IS
1973: SELECT concatenated_segments
1974: FROM mtl_system_items_kfv
1975: WHERE inventory_item_id = V_inventory_item_id;
1976:
1977: CURSOR Cur_get_org_id (V_org_code VARCHAR2) IS
1978: SELECT organization_id