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

Line 31: from gl_sets_of_books gsb,

27: order by distribution_id;
28:
29: cursor acct_exist(acct_id number) is
30: select count(*)
31: from gl_sets_of_books gsb,
32: financials_system_parameters fsp,
33: gl_code_combinations gl
34: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
35: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID

Line 786: FROM gl_sets_of_books,

782: and nvl(org_id, -9999) = nvl(oo_id,-9999);
783:
784: CURSOR chart_account_id IS
785: SELECT CHART_OF_ACCOUNTS_ID
786: FROM gl_sets_of_books,
787: financials_system_parameters fsp
788: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
789:
790: cursor get_cart_line_number(cartid number,cartline_id number) is

Line 788: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

784: CURSOR chart_account_id IS
785: SELECT CHART_OF_ACCOUNTS_ID
786: FROM gl_sets_of_books,
787: financials_system_parameters fsp
788: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
789:
790: cursor get_cart_line_number(cartid number,cartline_id number) is
791: select cart_line_number
792: from icx_shopping_cart_lines

Line 911: FROM gl_sets_of_books,

907: and nvl(org_id, -9999) = nvl(oo_id,-9999);
908:
909: CURSOR chart_account_id IS
910: SELECT CHART_OF_ACCOUNTS_ID
911: FROM gl_sets_of_books,
912: financials_system_parameters fsp
913: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
914:
915: cursor get_cart_line_number(cartid number,cartline_id number) is

Line 913: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

909: CURSOR chart_account_id IS
910: SELECT CHART_OF_ACCOUNTS_ID
911: FROM gl_sets_of_books,
912: financials_system_parameters fsp
913: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
914:
915: cursor get_cart_line_number(cartid number,cartline_id number) is
916: select cart_line_number
917: from icx_shopping_cart_lines

Line 1041: FROM gl_sets_of_books,

1037: and nvl(iscl.org_id,-9999) = nvl(v_oo_id,-9999);
1038:
1039: CURSOR chart_account_id IS
1040: SELECT CHART_OF_ACCOUNTS_ID
1041: FROM gl_sets_of_books,
1042: financials_system_parameters fsp
1043: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1044:
1045: cursor get_cart_line_number is

Line 1043: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

1039: CURSOR chart_account_id IS
1040: SELECT CHART_OF_ACCOUNTS_ID
1041: FROM gl_sets_of_books,
1042: financials_system_parameters fsp
1043: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1044:
1045: cursor get_cart_line_number is
1046: select cart_line_number
1047: from icx_shopping_cart_lines

Line 1090: from gl_sets_of_books gsb,

1086: close item_expense_account;
1087: end if;
1088: if v_account_id is not NULL then
1089: select count(*) into v_exist
1090: from gl_sets_of_books gsb,
1091: financials_system_parameters fsp,
1092: gl_code_combinations gl
1093: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
1094: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID

Line 1199: FROM gl_sets_of_books,

1195:
1196:
1197: CURSOR chart_account_id IS
1198: SELECT CHART_OF_ACCOUNTS_ID
1199: FROM gl_sets_of_books,
1200: financials_system_parameters fsp
1201: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1202:
1203: cursor get_cart_line_number is

Line 1201: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

1197: CURSOR chart_account_id IS
1198: SELECT CHART_OF_ACCOUNTS_ID
1199: FROM gl_sets_of_books,
1200: financials_system_parameters fsp
1201: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1202:
1203: cursor get_cart_line_number is
1204: select cart_line_number
1205: from icx_shopping_cart_lines

Line 1312: FROM gl_sets_of_books,

1308: v_error_message varchar2(2000);
1309:
1310: CURSOR chart_account_id IS
1311: SELECT CHART_OF_ACCOUNTS_ID
1312: FROM gl_sets_of_books,
1313: financials_system_parameters fsp
1314: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1315:
1316: v_account_id number;

Line 1314: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;

1310: CURSOR chart_account_id IS
1311: SELECT CHART_OF_ACCOUNTS_ID
1312: FROM gl_sets_of_books,
1313: financials_system_parameters fsp
1314: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1315:
1316: v_account_id number;
1317: v_account_num varchar2(2000);
1318: l_ret_cd BOOLEAN;