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.LNS_DISTRIBUTIONS_PUB dependencies on LNS_SYSTEM_OPTIONS

Line 1569: || Source Tables: lns_system_options

1565: || PARAMETERS p_loan_id = loan_id
1566: ||
1567: || Return value: new swap segment value
1568: ||
1569: || Source Tables: lns_system_options
1570: ||
1571: || Target Tables: NA
1572: ||
1573: || KNOWN ISSUES

Line 2497: || Source Tables: LNS_SYSTEM_OPTIONS, GL_SETS_OF_BOOKS

2493: || ,SHORT_NAME VARCHAR2(20)
2494: || ,CHART_OF_ACCOUNTS_ID NUMBER(15)
2495: || ,PERIOD_SET_NAME VARCHAR2(15));
2496: ||
2497: || Source Tables: LNS_SYSTEM_OPTIONS, GL_SETS_OF_BOOKS
2498: ||
2499: || Target Tables: NA
2500: ||
2501: || KNOWN ISSUES

Line 2522: FROM lns_system_options so,

2518: ,sb.chart_of_accounts_id
2519: ,sb.period_set_name
2520: ,sb.currency_code
2521: ,fndc.precision
2522: FROM lns_system_options so,
2523: gl_ledgers sb,
2524: fnd_currencies fndc
2525: WHERE sb.ledger_id = so.set_of_books_id
2526: and sb.currency_code = fndc.currency_code;

Line 2854: FROM lns_system_options so,

2850: and lnd.distribution_id = p_distribution_id;
2851:
2852: cursor c_currency2 is
2853: SELECT sb.currency_code
2854: FROM lns_system_options so,
2855: gl_sets_of_books sb
2856: WHERE sb.set_of_books_id = so.set_of_books_id;
2857:
2858: begin

Line 2898: | lns_system_options lso

Line 2925: , lns_system_options lso

2921: SELECT s.segment_num
2922: FROM fnd_id_flex_segments s
2923: , fnd_segment_attribute_values sav
2924: , fnd_segment_attribute_types sat
2925: , lns_system_options lso
2926: , gl_ledgers gl
2927: WHERE s.application_id = p_application_id
2928: and lso.set_of_books_id = gl.ledger_id
2929: AND s.id_flex_code = p_flex_code

Line 2970: | lns_system_options lso

Line 2994: ,lns_system_options lso

2990: SELECT s.flex_value_set_id
2991: FROM fnd_id_flex_segments s
2992: ,fnd_segment_attribute_values sav
2993: ,fnd_segment_attribute_types sat
2994: ,lns_system_options lso
2995: ,gl_ledgers gl
2996: WHERE s.application_id = 101
2997: and lso.set_of_books_id = gl.ledger_id
2998: AND s.id_flex_code = 'GL#'

Line 4313: lns_system_options sysop,

4309:
4310: CURSOR cur_default_ar_adj(c_loan_id NUMBER) IS
4311: SELECT rec.CODE_COMBINATION_ID
4312: FROM lns_loan_headers lhdr,
4313: lns_system_options sysop,
4314: ar_receivables_trx rec
4315: WHERE lhdr.loan_id = c_loan_id
4316: AND sysop.org_id = lhdr.org_id
4317: AND sysop.receivables_trx_id = rec.receivables_trx_id;

Line 9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl

9038: CURSOR loan_cur(C_LOAN_ID number) IS
9039: SELECT
9040: loan.loan_number, nvl(loan.disable_int_accrual_flag, 'N'), ou.name, gl.name
9041: FROM
9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl
9043: WHERE loan.loan_id = C_LOAN_ID
9044: AND loan.org_id = lsysopt.org_id
9045: AND lsysopt.set_of_books_id = gl.ledger_id
9046: AND loan.org_id = ou.organization_id;

Line 9089: lns_system_options so,

9085:
9086: CURSOR c_get_chart_acc_id(c_loan_id NUMBER) is
9087: SELECT sb.chart_of_accounts_id
9088: FROM lns_loan_headers lhdr,
9089: lns_system_options so,
9090: gl_ledgers sb,
9091: fnd_currencies fndc
9092: WHERE lhdr.loan_id = c_loan_id
9093: AND lhdr.org_id = so.org_id

Line 9103: GL_PERIOD_STATUSES glps, LNS_SYSTEM_OPTIONS sysopt, LNS_LOAN_HEADERS lhdr

9099: CURSOR cur_gl_period_status(C_LOAN_ID Number, C_PERIOD_NAME Varchar2) IS
9100: SELECT
9101: glps.closing_status
9102: FROM
9103: GL_PERIOD_STATUSES glps, LNS_SYSTEM_OPTIONS sysopt, LNS_LOAN_HEADERS lhdr
9104: WHERE lhdr.loan_id = C_LOAN_ID
9105: AND lhdr.org_id = sysopt.org_id
9106: AND sysopt.set_of_books_id = glps.ledger_id
9107: AND glps.application_id = 101

Line 9615: LNS_LOAN_HEADERS head, LNS_SYSTEM_OPTIONS sysopt

9611: CURSOR cur_loans_to_accrue_int(c_accrual_date DATE, C_LOAN_ID NUMBER, C_BORROWER_ID NUMBER, C_ORG_ID NUMBER, C_LEDGER_ID NUMBER) IS
9612: SELECT
9613: head.LOAN_ID
9614: FROM
9615: LNS_LOAN_HEADERS head, LNS_SYSTEM_OPTIONS sysopt
9616: WHERE
9617: head.org_id = sysopt.org_id
9618: AND sysopt.set_of_books_id = nvl(C_LEDGER_ID, sysopt.set_of_books_id)
9619: AND c_accrual_date >= NVL((select max(due_date) from LNS_AMORTIZATION_SCHEDS aschd

Line 10471: where gl_books.set_of_books_id = (select set_of_books_id from lns_system_options);

10467:
10468: cursor C_COA_DETAILS is
10469: select chart_of_accounts_id
10470: from gl_sets_of_books gl_books
10471: where gl_books.set_of_books_id = (select set_of_books_id from lns_system_options);
10472:
10473: cursor C_LOAN_DETAILS(p_loan_id in number) is
10474: select org_id
10475: from lns_loan_headers lh