DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 1155: FROM MTL_LOT_UOM_CLASS_CONVERSIONS MLUC,

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

Line 1176: FROM MTL_LOT_UOM_CLASS_CONVERSIONS MLUC,

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