1151: BEGIN
1152:
1153: SELECT COUNT(1)
1154: INTO L_MTLT_COUNT
1155: FROM MTL_LOT_UOM_CLASS_CONVERSIONS MLUC,
1156: MTL_TRANSACTION_LOTS_TEMP MTLT -- Used for form action
1157: WHERE MTLT.LOT_NUMBER = MLUC.LOT_NUMBER
1158: AND MLUC.ORGANIZATION_ID = P_TO_ORG_ID
1159: AND MLUC.INVENTORY_ITEM_ID = P_ITEM_ID
1172: x_progress := '006';
1173: BEGIN
1174: SELECT COUNT(1)
1175: INTO L_MTLI_COUNT
1176: FROM MTL_LOT_UOM_CLASS_CONVERSIONS MLUC,
1177: MTL_TRANSACTION_LOTS_INTERFACE MTLI -- Used for ROI&LOT action
1178: WHERE MTLI.LOT_NUMBER = MLUC.LOT_NUMBER
1179: AND MLUC.ORGANIZATION_ID = P_TO_ORG_ID
1180: AND MLUC.INVENTORY_ITEM_ID = P_ITEM_ID