DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on PO_LINES_ALL

Line 104: p_po_line_id po_lines_all.po_line_id%type ,

100:
101: /*------------------------------------------------------------------------------------------------------------*/
102: PROCEDURE ja_in_57f4_lines_insert
103: (p_po_header_id po_headers_all.po_header_id%type ,
104: p_po_line_id po_lines_all.po_line_id%type ,
105: p_po_release_id po_releases_all.po_release_id%type,
106: p_vendor_id po_vendors.vendor_id%type ,
107: p_vendor_site_id po_vendor_sites_all.vendor_site_id%type,
108: p_called_from varchar2

Line 246: FROM po_lines_all

242:
243: cursor c_po_line_cur is
244: SELECT po_line_id , item_id, unit_meas_lookup_code,
245: unit_price , line_type_id
246: FROM po_lines_all
247: WHERE po_line_id = p_po_line_id;
248:
249:
250: cursor c_location_id is

Line 768: FROM po_lines_all

764: AND organization_id = r_base_trx.organization_id;
765:
766: CURSOR c_po_line_info IS
767: SELECT unit_meas_lookup_code, unit_price
768: FROM po_lines_all
769: WHERE po_line_id = r_base_trx.po_line_id;
770:
771: CURSOR c_po_dist_info IS
772: SELECT po_distribution_id, wip_entity_id, wip_line_id,

Line 1151: from po_lines_all

1147: where line_location_id = p_po_line_location_id;
1148:
1149: CURSOR c_po_line_uom is
1150: select unit_meas_lookup_code
1151: from po_lines_all
1152: where po_line_id = p_po_line_id;
1153:
1154:
1155: --**********TO GET COUNT OF EXISTING 57F4'S**********

Line 1436: This has been corrected by using the unit_meas_lookup_code of the po_lines_all table

1432: instance . The value in this field is being used as a basis of uom comparison. This
1433: is causing wrong uom conversion and return quantuty is not getting updated correctly
1434: when uom is changed.
1435:
1436: This has been corrected by using the unit_meas_lookup_code of the po_lines_all table
1437: in case the value retreived from the po_line_locations_all table is null.
1438:
1439: 6 03-JUN-2004 Vijay Shankar for Bug# 3644845, Version:115.1
1440: return quantity is not getting updated when one of the OSP component is sent through Secondary form because the