DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_UOM_CONVERSIONS_VAL_V

Line 3899: FROM mtl_uom_conversions_val_v muc, mtl_units_of_measure muom

3895: p_organization_id,
3896: 0,
3897: x_uom_code)
3898: INTO x_uom_code
3899: FROM mtl_uom_conversions_val_v muc, mtl_units_of_measure muom
3900: WHERE muc.uom_class = l_class
3901: AND muc.item_id = 0
3902: AND NVL (muc.disable_date, SYSDATE + 1) > SYSDATE
3903: AND muc.unit_of_measure = muom.unit_of_measure

Line 3933: FROM mtl_uom_conversions_val_v muc, mtl_units_of_measure muom

3929: p_organization_id,
3930: 0,
3931: x_uom_code)
3932: INTO x_uom_code
3933: FROM mtl_uom_conversions_val_v muc, mtl_units_of_measure muom
3934: WHERE muc.uom_class = l_class
3935: AND muc.item_id = 0
3936: AND NVL (muc.disable_date, SYSDATE + 1) > SYSDATE
3937: AND muc.unit_of_measure = muom.unit_of_measure

Line 4023: mtl_uom_conversions_val_v muc ,

4019: AND ROWNUM=1;
4020: SELECT INV_UI_RCV_LOVS.get_conversion_rate_expense(muom.uom_code,p_organization_id ,0,x_uom_code )
4021: into x_uom_code
4022: from
4023: mtl_uom_conversions_val_v muc ,
4024: mtl_units_of_measure muom
4025: where muc.uom_class = l_class
4026: and muc.item_id = 0
4027: and nvl(muc.disable_date,sysdate+1)>sysdate

Line 4060: mtl_uom_conversions_val_v muc ,

4056: AND ROWNUM=1;
4057: SELECT INV_UI_RCV_LOVS.get_conversion_rate_expense(muom.uom_code, p_organization_id ,0,x_uom_code )
4058: into x_uom_code
4059: from
4060: mtl_uom_conversions_val_v muc ,
4061: mtl_units_of_measure muom
4062: where muc.uom_class = l_class
4063: and muc.item_id = 0
4064: and nvl(muc.disable_date,sysdate+1)>sysdate