DBA Data[Home] [Help]

APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 23: FROM mtl_system_items

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

Line 324: FROM mtl_system_items

320: vTransToPrimaryUOMConv NUMBER;
321:
322: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
323: SELECT primary_uom_code
324: FROM mtl_system_items
325: WHERE organization_id = p_organization_id
326: AND inventory_item_id = p_inventory_item_id;
327:
328: -- Quantity field used in the insert statement