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

Line 121: from gl_sets_of_books gsob,

117:
118: cursor getCurrency is
119: select gsob.CURRENCY_CODE,
120: fc.PRECISION
121: from gl_sets_of_books gsob,
122: FND_CURRENCIES fc,
123: org_organization_definitions ood
124: where ood.ORGANIZATION_ID = v_org
125: and fc.CURRENCY_CODE = gsob.CURRENCY_CODE

Line 817: from gl_sets_of_books,

813:
814:
815: cursor get_acct is
816: select CHART_OF_ACCOUNTS_ID
817: from gl_sets_of_books,
818: financials_system_parameters fsp
819: where gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
820:
821: cursor invalid_locations(l_cart_id number, v_oo_id number) is

Line 819: where gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

815: cursor get_acct is
816: select CHART_OF_ACCOUNTS_ID
817: from gl_sets_of_books,
818: financials_system_parameters fsp
819: where gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
820:
821: cursor invalid_locations(l_cart_id number, v_oo_id number) is
822: select cart_line_number, DELIVER_TO_LOCATION
823: from icx_shopping_cart_lines

Line 2115: from gl_sets_of_books gsb,

2111: storeerror(v_cart_id, v_error_message);
2112: else
2113: if (v_account_id is not null) then
2114: select count(*) into v_exist
2115: from gl_sets_of_books gsb,
2116: financials_system_parameters fsp,
2117: gl_code_combinations gl
2118: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
2119: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID