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_SHARED_PROC_PVT dependencies on GL_SETS_OF_BOOKS

Line 249: l_coa_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

245: p_inv_org_id IN NUMBER
246: )
247: RETURN NUMBER
248: IS
249: l_coa_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
250: BEGIN
251: --SQL WHAT: Derive the COA tied to a Set of Books that, in turn, is
252: -- tied to a Operating Unit to which a given Inventory Org belongs.
253: --SQL WHY: To define the Destination Account flexfield structure.

Line 256: FROM gl_sets_of_books gsb,

252: -- tied to a Operating Unit to which a given Inventory Org belongs.
253: --SQL WHY: To define the Destination Account flexfield structure.
254: SELECT gsb.chart_of_accounts_id
255: INTO l_coa_id
256: FROM gl_sets_of_books gsb,
257: hr_organization_information hoi,
258: mtl_parameters mp
259: WHERE mp.organization_id = p_inv_org_id
260: AND mp.organization_id = hoi.organization_id

Line 323: FROM gl_sets_of_books gsb,

319: -- Also, get the OU's org ID to which the Inventory Org belongs.
320: --SQL WHY: To define the Destination Account flexfield structure.
321: SELECT TO_NUMBER(hoi.org_information3), gsb.chart_of_accounts_id
322: INTO x_ou_id, x_coa_id
323: FROM gl_sets_of_books gsb,
324: hr_organization_information hoi,
325: mtl_parameters mp
326: WHERE mp.organization_id = p_inv_org_id
327: AND mp.organization_id = hoi.organization_id