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.JE_BE_CSSR_PKG dependencies on GL_CODE_COMBINATIONS

Line 367: l_coa_id gl_code_combinations.CHART_OF_ACCOUNTS_ID%type;

363: l_rub varchar2(240);
364:
365: l_disp_period gl_periods.period_name%type;
366: l_sob_id gl_sets_of_books.set_of_books_id%type;
367: l_coa_id gl_code_combinations.CHART_OF_ACCOUNTS_ID%type;
368: l_seg_name fnd_id_flex_segments.application_column_name%type;
369: l_cc_id gl_code_combinations.code_combination_id%type;
370: l_start_date date;
371: l_end_date date;

Line 369: l_cc_id gl_code_combinations.code_combination_id%type;

365: l_disp_period gl_periods.period_name%type;
366: l_sob_id gl_sets_of_books.set_of_books_id%type;
367: l_coa_id gl_code_combinations.CHART_OF_ACCOUNTS_ID%type;
368: l_seg_name fnd_id_flex_segments.application_column_name%type;
369: l_cc_id gl_code_combinations.code_combination_id%type;
370: l_start_date date;
371: l_end_date date;
372: l_status_text varchar2(2000);
373: l_data_string varchar2(200);

Line 458: gl_code_combinations glcc,

454: FROM
455: ap_invoices_all ap_inv,
456: ap_supplier_sites_all ven ,
457: ap_invoice_distributions_all ap_dist ,
458: gl_code_combinations glcc,
459: fnd_lookup_values lv
460: WHERE ap_inv.vendor_site_id = ven.vendor_site_id
461: AND ap_dist.invoice_id = ap_inv.invoice_id
462: AND ap_dist.dist_code_combination_id = glcc.code_combination_id

Line 496: gl_code_combinations glcc,

492: hz_party_sites hz_ps ,
493: hz_locations hzl ,
494: hz_cust_site_uses_all hz_csu ,
495: hz_cust_acct_sites_all hz_cas ,
496: gl_code_combinations glcc,
497: fnd_lookup_values lv
498: WHERE
499: gld.customer_trx_id = trx.customer_trx_id
500: AND trx.BILL_TO_customer_ID = HZ_CUST.cust_account_id

Line 546: gl_code_combinations glcc,

542: FROM
543: ap_invoices_all ap_inv,
544: ap_supplier_sites_all ven ,
545: ap_invoice_distributions_all ap_dist ,
546: gl_code_combinations glcc,
547: fnd_lookup_values lv
548: WHERE ap_inv.vendor_site_id = ven.vendor_site_id
549: AND ap_dist.invoice_id = ap_inv.invoice_id
550: AND ap_dist.dist_code_combination_id = glcc.code_combination_id

Line 585: gl_code_combinations glcc,

581: hz_party_sites hz_ps ,
582: hz_locations hzl ,
583: hz_cust_site_uses_all hz_csu ,
584: hz_cust_acct_sites_all hz_cas ,
585: gl_code_combinations glcc,
586: fnd_lookup_values lv
587: WHERE
588: gld.customer_trx_id = trx.customer_trx_id
589: AND trx.BILL_TO_customer_ID = HZ_CUST.cust_account_id

Line 845: ' FROM gl_code_combinations '||

841: AND application_id = 101
842: AND id_flex_num = p_choac_id;
843:
844: EXECUTE IMMEDIATE 'SELECT '||l_segment ||
845: ' FROM gl_code_combinations '||
846: ' WHERE code_combination_id = '||p_cc_id
847: INTO bal_segment_value;
848:
849: RETURN (bal_segment_value);

Line 893: ' FROM gl_code_combinations '||

889:
890: IF p_cc_id IS NOT NULL THEN
891:
892: EXECUTE IMMEDIATE 'SELECT '||l_segment ||
893: ' FROM gl_code_combinations '||
894: ' WHERE code_combination_id = '||p_cc_id||
895: ' AND chart_of_accounts_id = '||p_coa_id
896: INTO l_segment_value;
897: