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

Line 34: FROM gl_sets_of_books glsob,

30:
31: CURSOR currency_code_cur (p_organization_id NUMBER) IS
32: SELECT glsob.currency_code
33: ,glsob.chart_of_accounts_id
34: FROM gl_sets_of_books glsob,
35: hr_organization_information hoi
36: WHERE glsob.set_of_books_id = hoi.org_information1
37: AND hoi.org_information_context ||'' = 'Accounting Information'
38: AND hoi.organization_id = p_organization_id;

Line 61: gl_sets_of_books glsob,

57: trunc(sysdate),
58: psp.DEFAULT_RATE_TYPE,
59: 30),10)
60: FROM mtl_system_items msi,
61: gl_sets_of_books glsob,
62: hr_organization_information hoi,
63: po_system_parameters psp
64: WHERE msi.inventory_item_id = p_item_id
65: AND hoi.organization_id = p_source_organization_id

Line 77: FROM gl_sets_of_books glsob,

73: glsob.currency_code,
74: trunc(sysdate),
75: psp.DEFAULT_RATE_TYPE,
76: 30),10)
77: FROM gl_sets_of_books glsob,
78: hr_organization_information hoi,
79: po_system_parameters psp
80: WHERE hoi.organization_id = p_source_organization_id
81: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information'

Line 1803: FROM GL_SETS_OF_BOOKS GLSOB,

1799: IF (l_currency_code IS NULL) THEN
1800: BEGIN
1801: SELECT glsob.CURRENCY_CODE
1802: INTO l_currency_code
1803: FROM GL_SETS_OF_BOOKS GLSOB,
1804: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1805: WHERE GLSOB.SET_OF_BOOKS_ID=FSP.SET_OF_BOOKS_ID
1806: AND nvl(FSP.org_id,-1) = l_source_operating_unit;
1807: