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.PA_CI_SUPPLIER_UTILS dependencies on PO_HEADERS_ALL

Line 107: FROM po_headers_all po

103:
104: PROCEDURE validate_PO(c_vendor_id number,l_error_msg OUT NOCOPY varchar2) IS
105: cursor cur_po is
106: SELECT po.po_header_id
107: FROM po_headers_all po
108: WHERE po.segment1 = p_po_number
109: AND po.vendor_id = c_vendor_id
110: /* added this condition to cehck Po status is OPEN or APPRVOED */
111: AND NVL(po.closed_code,'XX') NOT in ('FINALLY CLOSED','CLOSED')

Line 159: ,po_headers_all poh

155: ,l_error_msg OUT NOCOPY varchar2) IS
156: cursor cur_po_line is
157: SELECT pol.po_line_id
158: FROM po_lines_all pol
159: ,po_headers_all poh
160: WHERE pol.po_header_id = poh.po_header_id
161: AND poh.po_header_id = c_po_header_id
162: AND pol.line_num = c_po_line_num
163: /* added this condition to cehck Po status is OPEN or APPRVOED */

Line 216: FROM po_headers_all po

212:
213: PROCEDURE Validate_Currency(c_po_header_id number,l_error_msg OUT NOCOPY varchar2) IS
214: cursor cur_po_currency IS
215: SELECT po.currency_code
216: FROM po_headers_all po
217: WHERE po.po_header_id = c_po_header_id
218: AND po.currency_code = p_currency_code;
219:
220: cursor cur_currency is