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.PON_SOURCING_OPENAPI_GRP dependencies on PO_LINES

Line 1531: select uda_template_id into l_src_template_id from po_lines_all where po_header_id = g_header_rec.source_doc_id and rownum<2;

1527:
1528: for i in 1..l_lineno_list.count
1529: loop
1530: if ( i = 1 ) Then
1531: select uda_template_id into l_src_template_id from po_lines_all where po_header_id = g_header_rec.source_doc_id and rownum<2;
1532: end if;
1533: select source_line_id into l_poline_id from pon_auc_items_interface where
1534: interface_auction_header_id = p_interface_id and interface_line_number = l_lineno_list(i);
1535:

Line 1932: (SELECT clm_exhibit_name FROM po_lines pl

1928: end if;
1929:
1930: UPDATE pon_auction_item_prices_all ai
1931: SET exhibit_number =
1932: (SELECT clm_exhibit_name FROM po_lines pl
1933: WHERE pl.po_header_id = ai.source_doc_id
1934: AND pl.po_line_id = ai.source_line_id)
1935: WHERE ai.auction_header_id = x_document_number;
1936: