DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1090: FROM MTL_TRANSACTION_LOTS_TEMP

1086: --For interclass end Bug15932062
1087:
1088: CURSOR LOT_NUM_CUR(P_INTERFACE_TRANSACTION_ID NUMBER) IS
1089: SELECT TRANSACTION_QUANTITY, LOT_NUMBER
1090: FROM MTL_TRANSACTION_LOTS_TEMP
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

Line 1156: MTL_TRANSACTION_LOTS_TEMP MTLT -- Used for form action

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