APPS.GML_OPM_PO dependencies on MTL_SYSTEM_ITEMS_B

Line 21: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

17: END IF;
18: END CHECK_OPM_PO;
19:
20: FUNCTION CHECK_OPM_ITEM_BY_ORA_ID
21: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
22: p_organization_id IN mtl_system_items_b.organization_id%TYPE
23: ) RETURN NUMBER IS
24:
25: v_item_no mtl_system_items_b.segment1%TYPE;

Line 22: p_organization_id IN mtl_system_items_b.organization_id%TYPE

18: END CHECK_OPM_PO;
19:
20: FUNCTION CHECK_OPM_ITEM_BY_ORA_ID
21: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
22: p_organization_id IN mtl_system_items_b.organization_id%TYPE
23: ) RETURN NUMBER IS
24:
25: v_item_no mtl_system_items_b.segment1%TYPE;
26: opmitem NUMBER;

Line 25: v_item_no mtl_system_items_b.segment1%TYPE;

21: ( p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
22: p_organization_id IN mtl_system_items_b.organization_id%TYPE
23: ) RETURN NUMBER IS
24:
25: v_item_no mtl_system_items_b.segment1%TYPE;
26: opmitem NUMBER;
27:
28: CURSOR item_cur IS
29: SELECT segment1

Line 30: FROM mtl_system_items_b

26: opmitem NUMBER;
27:
28: CURSOR item_cur IS
29: SELECT segment1
30: FROM mtl_system_items_b
31: WHERE inventory_item_id = p_inventory_item_id AND
32: organization_id = p_organization_id;
33:
34: BEGIN