eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_SYNCH_BPOS dependencies on PO_LINES_ALL

Line 180: | 25-APR-00 N Chekuri Changed to return line_num from po_lines_all instead|

176: | MODIFICATION HISTORY |
177: | |
178: | 26-OCT-97 R Chellam Created |
179: | 20-NOV-97 R Chellam Modified to deal only with PPOs |
180: | 25-APR-00 N Chekuri Changed to return line_num from po_lines_all instead|
181: | of the max(line_no) from po_bpos_dtl. Bug#1246767. |
182: | Changed parameter accordingly.
183: | 15-MAY-00 N Chekuri Added logic to take care of more than one shipment |
184: | line per PO line. Added parameters.

Line 205: FROM po_lines_all

201: more than one shipment per line */
202:
203: SELECT count(*)
204: INTO v_line_count
205: FROM po_lines_all
206: WHERE po_header_id = v_po_header_id;
207:
208: SELECT count(*)
209: INTO v_shipment_count

Line 216: FROM po_lines_all

212:
213: IF v_line_count = v_shipment_count THEN
214: SELECT line_num
215: INTO v_bpo_line_no
216: FROM po_lines_all
217: WHERE po_line_id = v_po_line_id;
218: ELSE
219: SELECT NVL(MAX(line_no),0) +1
220: INTO v_bpo_line_no