[Home] [Help]
3810: l_progress := '30';
3811: BEGIN
3812: SELECT inv_ui_item_lovs.get_conversion_rate (mum.uom_code, p_organization_id, rsl.item_id)
3813: INTO x_uom_code
3814: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3815: WHERE rsl.shipment_header_id = p_shipment_header_id
3816: AND rsl.unit_of_measure IS NOT NULL
3817: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3818: AND rsl.item_id = p_item_id
3880: l_progress := '20';
3881: BEGIN
3882: SELECT mum.uom_code, mum.uom_class
3883: INTO x_uom_code, l_class
3884: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3885: WHERE rsl.shipment_header_id = p_shipment_header_id
3886: AND rsl.unit_of_measure IS NOT NULL
3887: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3888: AND rsl.item_description = p_item_desc
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
3914: l_progress := '30';
3915: BEGIN
3916: SELECT mum.uom_code, mum.uom_class
3917: INTO x_uom_code, l_class
3918: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3919: WHERE rsl.shipment_header_id = p_shipment_header_id
3920: AND rsl.unit_of_measure IS NOT NULL
3921: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3922: AND rsl.item_id IS NULL
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
4000: l_progress := '20';
4001: BEGIN
4002: SELECT mum.uom_code, mum.uom_class
4003: INTO x_uom_code, l_class
4004: FROM po_lines pol, mtl_units_of_measure mum
4005: WHERE pol.po_header_id = p_po_header_id
4006: AND pol.unit_meas_lookup_code IS NOT NULL
4007: AND pol.line_num = p_line_no
4008: AND pol.unit_meas_lookup_code = mum.unit_of_measure
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
4028: and muc.unit_of_measure = muom.unit_of_measure
4037: l_progress := '30';
4038: BEGIN
4039: SELECT mum.uom_code, mum.uom_class
4040: INTO x_uom_code, l_class
4041: FROM po_lines pol, mtl_units_of_measure mum
4042: WHERE pol.po_header_id = p_po_header_id
4043: AND pol.unit_meas_lookup_code IS NOT NULL
4044: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4045: AND pol.item_description = p_item_desc
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
4065: and muc.unit_of_measure = muom.unit_of_measure
4104: p_organization_id,
4105: pol.item_id)
4106: INTO x_uom_code
4107: FROM po_lines pol
4108: , mtl_units_of_measure mum
4109: WHERE pol.po_header_id = p_po_header_id
4110: AND pol.unit_meas_lookup_code IS NOT NULL
4111: AND pol.item_id = p_item_id
4112: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
8168: l_progress := '20';
8169: BEGIN
8170: SELECT DISTINCT mum.uom_code
8171: INTO l_uom_code
8172: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
8173: WHERE rt.transaction_type = 'RECEIVE'
8174: AND rsl.item_id = p_item_id
8175: AND rt.organization_id = p_organization_id
8176: AND rsl.shipment_header_id = rt.shipment_header_id