DBA Data[Home] [Help]

APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 22: FROM mtl_system_items

18: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
19: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
21: SELECT primary_uom_code
22: FROM mtl_system_items
23: WHERE organization_id = p_organization_id
24: AND inventory_item_id = p_inventory_item_id;
25:
26: vTransToPrimaryUOMConv NUMBER;

Line 282: FROM mtl_system_items

278: vTransToPrimaryUOMConv NUMBER;
279:
280: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
281: SELECT primary_uom_code
282: FROM mtl_system_items
283: WHERE organization_id = p_organization_id
284: AND inventory_item_id = p_inventory_item_id;
285:
286: -- Quantity field used in the insert statement