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

Line 193: gl_sets_of_books SOB

189: *----------------------------------------------------*/
190: SELECT NVL(SLA_LEDGER_CASH_BASIS_FLAG, 'N')
191: INTO l_cash_basis
192: FROM ap_system_parameters_all ASP,
193: gl_sets_of_books SOB
194: WHERE asp.org_id = x_org_id
195: AND asp.set_of_books_id = sob.set_of_books_id;
196:
197: /*---------------------------------------------------

Line 494: gl_sets_of_books SOB,

490:
491: SELECT NVL(sla_ledger_cash_basis_flag, 'N')
492: INTO l_cash_basis
493: FROM ap_system_parameters ASP,
494: gl_sets_of_books SOB,
495: ap_invoices AI
496: WHERE AI.invoice_id = x_invoice_id
497: AND AI.org_id = ASP.org_id
498: AND asp.set_of_books_id = sob.set_of_books_id;

Line 816: from gl_sets_of_books

812:
813: --Start Bug#10241241
814: select chart_of_accounts_id
815: into l_chart_of_accounts_id
816: from gl_sets_of_books
817: where set_of_books_id = l_set_of_books_id;
818:
819: l_dist_updated := 0;
820: --End Bug#10241241

Line 1448: gl_sets_of_books gsob

1444: ap_invoices AI,
1445: ap_suppliers PV,
1446: po_distributions PD,
1447: ap_system_parameters ap,
1448: gl_sets_of_books gsob
1449: WHERE AI.invoice_id = X_invoice_id
1450: AND AID.invoice_id = AI.invoice_id
1451: AND AID.invoice_line_number =
1452: NVL(X_line_number, invoice_line_number)

Line 3614: FROM gl_sets_of_books

3610: BEGIN
3611:
3612: SELECT chart_of_accounts_id
3613: INTO l_coa_id
3614: FROM gl_sets_of_books
3615: WHERE set_of_books_id = X_Sob_Id;
3616:
3617: -- Get the segments of the two given accounts
3618: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

Line 3668: FROM gl_sets_of_books

3664: BEGIN
3665:
3666: SELECT chart_of_accounts_id
3667: INTO l_coa_id
3668: FROM gl_sets_of_books
3669: WHERE set_of_books_id = X_Sob_Id;
3670:
3671: -- Get the delimiter
3672: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_coa_id);

Line 3989: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

3985: AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
3986: l_dist_ccid
3987: AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
3988: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
3989: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3990: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3991: l_assets_tracking_flag
3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;

Line 4241: FROM ap_system_parameters ap, gl_sets_of_books gsob

4237: debug_info := 'Get system information';
4238: BEGIN
4239: SELECT gsob.chart_of_accounts_id, ap.base_currency_code
4240: INTO l_chart_of_accounts_id, l_base_currency_code
4241: FROM ap_system_parameters ap, gl_sets_of_books gsob
4242: WHERE ap.set_of_books_id = gsob.set_of_books_id
4243: AND ap.set_of_books_id = l_invoice_line_rec.set_of_books_id
4244: AND ap.org_id = l_invoice_line_rec.org_id; -- Bug 13858818.
4245:

Line 5235: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

5231:
5232: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5233: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
5234: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5235: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 5426: FROM ap_system_parameters ap, gl_sets_of_books gsob

5422: debug_info := 'Get system information';
5423: BEGIN
5424: SELECT gsob.chart_of_accounts_id, ap.base_currency_code
5425: INTO l_chart_of_accounts_id, l_base_currency_code
5426: FROM ap_system_parameters ap, gl_sets_of_books gsob
5427: WHERE ap.set_of_books_id = gsob.set_of_books_id
5428: AND ap.set_of_books_id = l_invoice_line_rec.set_of_books_id
5429: AND ap.org_id = l_invoice_line_rec.org_id; -- Bug 13858818
5430:

Line 6027: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

6023: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
6024: X_vendor_id IN NUMBER,
6025: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
6026: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
6027: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
6028: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
6029: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
6030: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
6031: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

Line 6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

6696: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
6697: l_org_id AP_INVOICE_LINES.ORG_ID%TYPE;
6698: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
6699: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;

Line 7192: FROM ap_system_parameters ap, gl_sets_of_books gsob

7188: SELECT gsob.chart_of_accounts_id, ap.base_currency_code,
7189: ap.allow_flex_override_flag
7190: INTO l_chart_of_accounts_id, l_base_currency_code,
7191: l_allow_po_override
7192: FROM ap_system_parameters ap, gl_sets_of_books gsob
7193: WHERE ap.set_of_books_id = gsob.set_of_books_id
7194: AND ap.org_id = l_org_id; -- Bug 13858818
7195:
7196: l_pa_allows_overrides :=