APPS.JAI_GENERAL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 74: FROM mtl_system_items

70: ) RETURN VARCHAR2 IS
71:
72: CURSOR c_item_flag(cp_organization_id IN NUMBER, cp_item_id IN NUMBER) IS
73: SELECT inventory_item_flag
74: FROM mtl_system_items
75: WHERE organization_id = cp_organization_id
76: AND inventory_item_id = cp_item_id;
77:
78: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

Line 78: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

74: FROM mtl_system_items
75: WHERE organization_id = cp_organization_id
76: AND inventory_item_id = cp_item_id;
77:
78: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
79:
80: lv_expense_flag VARCHAR2(1);
81: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.is_item_an_expense';
82:

Line 260: FROM mtl_system_items

256: FUNCTION get_primary_uom_code(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
257:
258: CURSOR c_get_primary_uom_code IS
259: SELECT primary_uom_code
260: FROM mtl_system_items
261: WHERE organization_id = p_organization_id
262: AND inventory_item_id = p_inventory_item_id;
263:
264: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;

Line 264: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;

260: FROM mtl_system_items
261: WHERE organization_id = p_organization_id
262: AND inventory_item_id = p_inventory_item_id;
263:
264: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;
265: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_primary_uom_code';
266:
267: BEGIN
268:

Line 357: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE

353:
354: FUNCTION trxn_to_primary_conv_rate(
355: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
356: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
357: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
358: ) RETURN NUMBER IS
359: vTransToPrimaryUOMConv NUMBER;
360: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';
361: BEGIN