eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_API_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1714: FROM mtl_system_items_kfv

1710: LocalCheckRecord c_check_recipe%ROWTYPE;
1711:
1712: CURSOR c_get_item(l_item_id NUMBER) IS
1713: SELECT description item_desc1, concatenated_segments item_no
1714: FROM mtl_system_items_kfv
1715: WHERE inventory_item_id = l_item_id;
1716: LocalItemRecord c_get_item%ROWTYPE;
1717:
1718: --Bug 6758122

Line 1949: FROM fm_matl_dtl d, mtl_system_items_kfv b

1945: WHERE formula_id = p_formula_id;
1946:
1947: CURSOR Cur_check_item_revision (V_organization_id NUMBER) IS
1948: SELECT d.revision, b.concatenated_segments
1949: FROM fm_matl_dtl d, mtl_system_items_kfv b
1950: WHERE formula_id = p_formula_id
1951: AND b.inventory_item_id = d.inventory_item_id
1952: AND b.organization_id = V_organization_id
1953: AND revision IS NOT NULL

Line 1994: FROM mtl_system_items_kfv

1990:
1991:
1992: CURSOR Cur_get_item_no (V_inventory_item_id NUMBER) IS
1993: SELECT concatenated_segments
1994: FROM mtl_system_items_kfv
1995: WHERE inventory_item_id = V_inventory_item_id;
1996:
1997: CURSOR Cur_get_org_id (V_org_code VARCHAR2) IS
1998: SELECT organization_id