APPS.INV_RCV_COMMON_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 3521: FROM po_lines pol, mtl_units_of_measure mum

3517: l_progress := '20';
3518: BEGIN
3519: SELECT mum.uom_code, mum.uom_class
3520: INTO x_uom_code, l_class
3521: FROM po_lines pol, mtl_units_of_measure mum
3522: WHERE pol.po_header_id = p_po_header_id
3523: AND pol.unit_meas_lookup_code IS NOT NULL
3524: AND pol.line_num = p_line_no
3525: AND pol.unit_meas_lookup_code = mum.unit_of_measure

Line 3541: mtl_units_of_measure muom

3537: SELECT INV_UI_RCV_LOVS.get_conversion_rate_expense(muom.uom_code,p_organization_id ,0,x_uom_code )
3538: into x_uom_code
3539: from
3540: mtl_uom_conversions_val_v muc ,
3541: mtl_units_of_measure muom
3542: where muc.uom_class = l_class
3543: and muc.item_id = 0
3544: and nvl(muc.disable_date,sysdate+1)>sysdate
3545: and muc.unit_of_measure = muom.unit_of_measure

Line 3558: FROM po_lines pol, mtl_units_of_measure mum

3554: l_progress := '30';
3555: BEGIN
3556: SELECT mum.uom_code, mum.uom_class
3557: INTO x_uom_code, l_class
3558: FROM po_lines pol, mtl_units_of_measure mum
3559: WHERE pol.po_header_id = p_po_header_id
3560: AND pol.unit_meas_lookup_code IS NOT NULL
3561: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3562: AND pol.item_description = p_item_desc

Line 3578: mtl_units_of_measure muom

3574: SELECT INV_UI_RCV_LOVS.get_conversion_rate_expense(muom.uom_code, p_organization_id ,0,x_uom_code )
3575: into x_uom_code
3576: from
3577: mtl_uom_conversions_val_v muc ,
3578: mtl_units_of_measure muom
3579: where muc.uom_class = l_class
3580: and muc.item_id = 0
3581: and nvl(muc.disable_date,sysdate+1)>sysdate
3582: and muc.unit_of_measure = muom.unit_of_measure

Line 3625: , mtl_units_of_measure mum

3621: p_organization_id,
3622: pol.item_id)
3623: INTO x_uom_code
3624: FROM po_lines pol
3625: , mtl_units_of_measure mum
3626: WHERE pol.po_header_id = p_po_header_id
3627: AND pol.unit_meas_lookup_code IS NOT NULL
3628: AND pol.item_id = p_item_id
3629: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE

Line 7640: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum

7636: l_progress := '20';
7637: BEGIN
7638: SELECT DISTINCT mum.uom_code
7639: INTO l_uom_code
7640: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
7641: WHERE rt.transaction_type = 'RECEIVE'
7642: AND rsl.item_id = p_item_id
7643: AND rt.organization_id = p_organization_id
7644: AND rsl.shipment_header_id = rt.shipment_header_id