DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 53: FROM mtl_system_items

49: ) RETURN VARCHAR2 IS
50:
51: CURSOR c_item_flag(cp_organization_id IN NUMBER, cp_item_id IN NUMBER) IS
52: SELECT inventory_item_flag
53: FROM mtl_system_items
54: WHERE organization_id = cp_organization_id
55: AND inventory_item_id = cp_item_id;
56:
57: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

Line 57: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

53: FROM mtl_system_items
54: WHERE organization_id = cp_organization_id
55: AND inventory_item_id = cp_item_id;
56:
57: lv_inv_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
58:
59: lv_expense_flag VARCHAR2(1);
60: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.is_item_an_expense';
61:

Line 239: FROM mtl_system_items

235: FUNCTION get_primary_uom_code(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
236:
237: CURSOR c_get_primary_uom_code IS
238: SELECT primary_uom_code
239: FROM mtl_system_items
240: WHERE organization_id = p_organization_id
241: AND inventory_item_id = p_inventory_item_id;
242:
243: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;

Line 243: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;

239: FROM mtl_system_items
240: WHERE organization_id = p_organization_id
241: AND inventory_item_id = p_inventory_item_id;
242:
243: lv_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;
244: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_primary_uom_code';
245:
246: BEGIN
247:

Line 336: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE

332:
333: FUNCTION trxn_to_primary_conv_rate(
334: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
335: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
336: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
337: ) RETURN NUMBER IS
338: vTransToPrimaryUOMConv NUMBER;
339: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';
340: BEGIN