DBA Data[Home] [Help]

APPS.INV_INVARCTA_XMLP_PKG dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 315: MTL_UOM_CONVERSIONS_VIEW

311: SELECT
312: CONVERSION_RATE
313: INTO CUR_RATE
314: FROM
315: MTL_UOM_CONVERSIONS_VIEW
316: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
317: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
318: AND PRIMARY_UOM_CODE = UOM
319: AND UOM_CODE = COUNT_UOM_CURRENT;

Line 340: MTL_UOM_CONVERSIONS_VIEW

336: SELECT
337: CONVERSION_RATE
338: INTO PRIOR_RATE
339: FROM
340: MTL_UOM_CONVERSIONS_VIEW
341: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
342: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
343: AND PRIMARY_UOM_CODE = UOM
344: AND UOM_CODE = COUNT_UOM_PRIOR;

Line 365: MTL_UOM_CONVERSIONS_VIEW

361: SELECT
362: CONVERSION_RATE
363: INTO FIRST_RATE
364: FROM
365: MTL_UOM_CONVERSIONS_VIEW
366: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
367: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
368: AND PRIMARY_UOM_CODE = UOM
369: AND UOM_CODE = COUNT_UOM_FIRST;