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.PO_AUTO_LINE_PROCESS_PVT dependencies on GL_SETS_OF_BOOKS

Line 141: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;

137: p_rate_type IN VARCHAR2,
138: p_rate_date IN DATE,
139: x_rate OUT NOCOPY NUMBER )
140: IS
141: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
142: l_po_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
143: l_inverse_rate_display_flag VARCHAR2 (1) := 'N';
144: l_display_rate NUMBER;
145: l_progress VARCHAR2 (3) := '000';

Line 142: l_po_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;

138: p_rate_date IN DATE,
139: x_rate OUT NOCOPY NUMBER )
140: IS
141: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
142: l_po_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
143: l_inverse_rate_display_flag VARCHAR2 (1) := 'N';
144: l_display_rate NUMBER;
145: l_progress VARCHAR2 (3) := '000';
146: l_rate_type po_headers_interface.rate_type%TYPE;

Line 4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;

4729: l_precision FND_CURRENCIES.precision%TYPE;
4730: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
4731: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

Line 4806: -- Join to financials_system_params_all and gl_sets_of_books to

4802: PO_DEBUG.debug_stmt(l_log_head,l_progress,'p_interface_source_code IN (SOURCING, CONSUMPTION ADVICE) - no currency conversion performed');
4803:
4804: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
4805: -- Retrieve information from the backing Requisition Line.
4806: -- Join to financials_system_params_all and gl_sets_of_books to
4807: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
4808: l_progress :='060';
4809: SELECT PRL.currency_code ,
4810: GSB.currency_code ,

Line 4823: gl_sets_of_books GSB

4819: l_req_amount ,
4820: l_req_currency_amount
4821: FROM po_requisition_lines_all PRL,
4822: financials_system_params_all FSP,
4823: gl_sets_of_books GSB
4824: WHERE PRL.requisition_line_id = p_requisition_line_id
4825: AND NVL(PRL.org_id, -99) = NVL(FSP.org_id, -99)
4826: AND FSP.set_of_books_id = GSB.set_of_books_id;
4827: -- If the Req and PO Currency are the same, then simply take the