DBA Data[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2086: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

2082: BEGIN
2083:
2084: SELECT count(*)
2085: into L_PENDING_COUNT
2086: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
2087: WHERE INVENTORY_ITEM_ID = P_ITEM_ID;
2088:
2089: EXCEPTION
2090: WHEN NO_DATA_FOUND THEN

Line 3029: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

3025: BEGIN
3026:
3027: SELECT 1
3028: INTO L_PENDING_COUNT
3029: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
3030: WHERE MMTT.INVENTORY_ITEM_ID = P_ITEM_ID
3031: AND MMTT.ORGANIZATION_ID = P_ORG_ID
3032: AND EXISTS( SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP MTLT
3033: WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID