APPS.PO_UOM_S dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1095: FROM MTL_TRANSACTION_LOTS_INTERFACE

1091: WHERE PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID;
1092:
1093: CURSOR LOT_NUM_INT_CUR(P_INTERFACE_TRANSACTION_ID NUMBER) IS
1094: SELECT TRANSACTION_QUANTITY, LOT_NUMBER
1095: FROM MTL_TRANSACTION_LOTS_INTERFACE
1096: WHERE PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID;
1097:
1098: BEGIN
1099:

Line 1177: MTL_TRANSACTION_LOTS_INTERFACE MTLI -- Used for ROI&LOT action

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
1181: AND MLUC.FROM_UNIT_OF_MEASURE = l_base_fuom