DBA Data[Home] [Help]

APPS.INV_INVIRILC_XMLP_PKG dependencies on MTL_UOM_CONVERSIONS

Line 54: MTL_UOM_CONVERSIONS F,

50: T.CONVERSION_RATE,
51: T.UOM_CLASS
52: INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
53: FROM
54: MTL_UOM_CONVERSIONS F,
55: MTL_UOM_CONVERSIONS T
56: WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
57: AND F.UOM_CODE = FROM_CODE
58: AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )

Line 55: MTL_UOM_CONVERSIONS T

51: T.UOM_CLASS
52: INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
53: FROM
54: MTL_UOM_CONVERSIONS F,
55: MTL_UOM_CONVERSIONS T
56: WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
57: AND F.UOM_CODE = FROM_CODE
58: AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
59: AND T.UOM_CODE = TO_CODE;

Line 235: MTL_UOM_CONVERSIONS F,

231: T.CONVERSION_RATE,
232: T.UOM_CLASS
233: INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
234: FROM
235: MTL_UOM_CONVERSIONS F,
236: MTL_UOM_CONVERSIONS T
237: WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
238: AND F.UOM_CODE = FROM_CODE
239: AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )

Line 236: MTL_UOM_CONVERSIONS T

232: T.UOM_CLASS
233: INTO FROM_RATE,FROM_CLASS,TO_RATE,TO_CLASS
234: FROM
235: MTL_UOM_CONVERSIONS F,
236: MTL_UOM_CONVERSIONS T
237: WHERE F.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
238: AND F.UOM_CODE = FROM_CODE
239: AND T.INVENTORY_ITEM_ID IN ( ITEM_ID , 0 )
240: AND T.UOM_CODE = TO_CODE;