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

Line 37: from gl_sets_of_books gsb,

33: order by distribution_id;
34:
35: cursor acct_exist(acct_id number) is
36: select count(*)
37: from gl_sets_of_books gsb,
38: financials_system_parameters fsp,
39: gl_code_combinations gl
40: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
41: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID

Line 263: gl_sets_of_books gsob

259:
260: cursor set_of_books is
261: SELECT fsp.set_of_books_id
262: FROM financials_system_parameters fsp,
263: gl_sets_of_books gsob
264: WHERE gsob.set_of_books_id = fsp.set_of_books_id
265: AND nvl(fsp.org_id, -9999) = nvl(v_oo_id, -9999);
266:
267: begin

Line 839: FROM gl_sets_of_books,

835: and nvl(a.org_id, -9999) = nvl(oo_id,-9999);
836:
837: CURSOR chart_account_id IS
838: SELECT CHART_OF_ACCOUNTS_ID
839: FROM gl_sets_of_books,
840: financials_system_parameters fsp
841: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
842:
843: cursor get_line_number(cartline_id number, oo_id number) is

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

837: CURSOR chart_account_id IS
838: SELECT CHART_OF_ACCOUNTS_ID
839: FROM gl_sets_of_books,
840: financials_system_parameters fsp
841: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
842:
843: cursor get_line_number(cartline_id number, oo_id number) is
844: select a.line_num
845: from po_requisition_lines a,

Line 972: FROM gl_sets_of_books,

968: and nvl(a.org_id, -9999) = nvl(v_oo_id,-9999);
969:
970: CURSOR chart_account_id IS
971: SELECT CHART_OF_ACCOUNTS_ID
972: FROM gl_sets_of_books,
973: financials_system_parameters fsp
974: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
975:
976: cursor get_req_line_number(reqline_id number) is

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

970: CURSOR chart_account_id IS
971: SELECT CHART_OF_ACCOUNTS_ID
972: FROM gl_sets_of_books,
973: financials_system_parameters fsp
974: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
975:
976: cursor get_req_line_number(reqline_id number) is
977: select a.line_num
978: from po_requisition_lines a,

Line 1118: FROM gl_sets_of_books,

1114: and nvl(iscl.org_id,-9999) = nvl(v_oo_id,-9999);
1115:
1116: CURSOR chart_account_id IS
1117: SELECT CHART_OF_ACCOUNTS_ID
1118: FROM gl_sets_of_books,
1119: financials_system_parameters fsp
1120: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1121:
1122: cursor get_cart_line_number is

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

1116: CURSOR chart_account_id IS
1117: SELECT CHART_OF_ACCOUNTS_ID
1118: FROM gl_sets_of_books,
1119: financials_system_parameters fsp
1120: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1121:
1122: cursor get_cart_line_number is
1123: select cart_line_number
1124: from icx_shopping_cart_lines

Line 1167: from gl_sets_of_books gsb,

1163: close item_expense_account;
1164: end if;
1165: if v_account_id is not NULL then
1166: select count(*) into v_exist
1167: from gl_sets_of_books gsb,
1168: financials_system_parameters fsp,
1169: gl_code_combinations gl
1170: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
1171: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID

Line 1274: FROM gl_sets_of_books,

1270:
1271:
1272: CURSOR chart_account_id IS
1273: SELECT CHART_OF_ACCOUNTS_ID
1274: FROM gl_sets_of_books,
1275: financials_system_parameters fsp
1276: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1277:
1278: cursor get_req_line_number is

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

1272: CURSOR chart_account_id IS
1273: SELECT CHART_OF_ACCOUNTS_ID
1274: FROM gl_sets_of_books,
1275: financials_system_parameters fsp
1276: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1277:
1278: cursor get_req_line_number is
1279: select a.line_num
1280: from po_requisition_lines a,

Line 1393: FROM gl_sets_of_books,

1389: v_error_message varchar2(2000);
1390:
1391: CURSOR chart_account_id IS
1392: SELECT CHART_OF_ACCOUNTS_ID
1393: FROM gl_sets_of_books,
1394: financials_system_parameters fsp
1395: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1396:
1397: v_account_id number;

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

1391: CURSOR chart_account_id IS
1392: SELECT CHART_OF_ACCOUNTS_ID
1393: FROM gl_sets_of_books,
1394: financials_system_parameters fsp
1395: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1396:
1397: v_account_id number;
1398: v_account_num varchar2(2000);
1399: l_ret_cd BOOLEAN;