APPS.GML_PROCESS_FLAGS dependencies on MTL_SYSTEM_ITEMS_B

Line 5: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE

1: PACKAGE BODY GML_PROCESS_FLAGS AS
2: /* $Header: GMLOPMFB.pls 115.3 2003/07/31 15:48:48 mchandak noship $ */
3:
4: FUNCTION CHECK_OPM_ITEM
5: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE
6: ) RETURN NUMBER IS
7:
8: v_item_no mtl_system_items_b.segment1%TYPE;
9: opmitem NUMBER;

Line 8: v_item_no mtl_system_items_b.segment1%TYPE;

4: FUNCTION CHECK_OPM_ITEM
5: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE
6: ) RETURN NUMBER IS
7:
8: v_item_no mtl_system_items_b.segment1%TYPE;
9: opmitem NUMBER;
10:
11: CURSOR item_distinct_cur IS
12: SELECT distinct segment1

Line 13: FROM mtl_system_items_b

9: opmitem NUMBER;
10:
11: CURSOR item_distinct_cur IS
12: SELECT distinct segment1
13: FROM mtl_system_items_b
14: WHERE inventory_item_id = nvl(p_inventory_item_id,-99);
15:
16: CURSOR opm_item IS
17: SELECT count(*)