[Home] [Help]
158:
159: /*------------------------------------------------------------------------------------------------------------*/
160: PROCEDURE ja_in_57f4_lines_insert
161: (p_po_header_id po_headers_all.po_header_id%type ,
162: p_po_line_id po_lines_all.po_line_id%type ,
163: p_po_release_id po_releases_all.po_release_id%type,
164: p_vendor_id po_vendors.vendor_id%type ,
165: p_vendor_site_id po_vendor_sites_all.vendor_site_id%type,
166: p_called_from varchar2
301:
302: cursor c_po_line_cur is
303: SELECT po_line_id , item_id, unit_meas_lookup_code,
304: unit_price , line_type_id
305: FROM po_lines_all
306: WHERE po_line_id = p_po_line_id;
307:
308:
309: cursor c_location_id is
885: AND organization_id = r_base_trx.organization_id;
886:
887: CURSOR c_po_line_info IS
888: SELECT unit_meas_lookup_code, unit_price
889: FROM po_lines_all
890: WHERE po_line_id = r_base_trx.po_line_id;
891:
892: CURSOR c_po_dist_info IS
893: SELECT po_distribution_id, wip_entity_id, wip_line_id,
1270: where line_location_id = p_po_line_location_id;
1271:
1272: CURSOR c_po_line_uom is
1273: select unit_meas_lookup_code
1274: from po_lines_all
1275: where po_line_id = p_po_line_id;
1276:
1277:
1278: --**********TO GET COUNT OF EXISTING 57F4'S**********
1597: instance . The value in this field is being used as a basis of uom comparison. This
1598: is causing wrong uom conversion and return quantuty is not getting updated correctly
1599: when uom is changed.
1600:
1601: This has been corrected by using the unit_meas_lookup_code of the po_lines_all table
1602: in case the value retreived from the po_line_locations_all table is null.
1603:
1604: 6 03-JUN-2004 Vijay Shankar for Bug# 3644845, Version:115.1
1605: return quantity is not getting updated when one of the OSP component is sent through Secondary form because the