eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UOM_API_PUB dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 1915: L_CONV_REC MTL_LOT_UOM_CLASS_CONVERSIONS%ROWTYPE;

1911: X_BATCH_QTY1 NUMBER;
1912: x_batch_qty2 NUMBER;
1913: X_LINE_TYPE NUMBER;
1914: X_BATCH_ID NUMBER(10);
1915: L_CONV_REC MTL_LOT_UOM_CLASS_CONVERSIONS%ROWTYPE;
1916: -- L_FROM_UNIT_OF_MEASURE VARCHAR(25);
1917: L_FROM_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1918: -- L_FROM_UOM_CLASS VARCHAR2(30);
1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;

Line 2485: FROM MTL_LOT_UOM_CLASS_CONVERSIONS

2481: -- Check if the lot uom conversion already present.
2482: BEGIN
2483: SELECT COUNT(1)
2484: INTO L_COUNT
2485: FROM MTL_LOT_UOM_CLASS_CONVERSIONS
2486: WHERE ORGANIZATION_ID = P_ORG_ID
2487: AND INVENTORY_ITEM_ID = P_ITEM_ID
2488: AND LOT_NUMBER = P_LOT_NUMBER
2489: AND TO_UOM_CODE = P_TO_UOM_CODE ;

Line 2527: FROM mtl_lot_uom_class_conversions

2523:
2524: BEGIN
2525: SELECT 1 --COUNT(1)
2526: INTO l_count
2527: FROM mtl_lot_uom_class_conversions
2528: WHERE organization_id = p_org_id
2529: AND inventory_item_id = p_item_id
2530: AND LOT_NUMBER = P_LOT_NUMBER
2531: AND TO_UOM_CODE = P_TO_UOM_CODE