DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_CODE_COMBINATIONS

Line 76: gl_code_combinations glcc,

72: 'SEGMENT27',glcc.segment27, 'SEGMENT28',glcc.segment28,
73: 'SEGMENT28',glcc.segment28, 'SEGMENT29',glcc.segment29,
74: 'SEGMENT30',glcc.segment30, NULL) account_code
75: FROM gl_je_headers gljh,
76: gl_code_combinations glcc,
77: gl_je_lines gljl
78: WHERE gljl.status = 'P'
79: AND gljl.period_name = x_period
80: AND gljl.ledger_id = x_sobid

Line 2589: , gl_code_combinations glcc --bug 10207969

2585: sysdate,
2586: bal.last_updated_by,
2587: bal.last_update_login
2588: FROM jl_co_gl_balances bal
2589: , gl_code_combinations glcc --bug 10207969
2590: WHERE (bal.period_year * 100 + bal.period_num) = l_pre_period_num
2591: AND bal.code_combination_id = glcc.code_combination_id --bug 10207969
2592: AND bal.set_of_books_id = p_sobid);
2593:

Line 2642: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt

2638: jlcgt.period_num pernum,
2639: glcc.account_type acctype,
2640: sum(nvl(jlcgt.accounted_dr,0)) acc_dr, --bug 10207969
2641: sum(nvl(jlcgt.accounted_cr,0)) acc_cr --bug 10207969
2642: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
2643: WHERE jlcgt.process_id IN ( SELECT process_id
2644: FROM jl_co_gl_conc_ctrl
2645: WHERE NVL(balance_calculated,'N') <> 'Y'
2646: AND set_of_books_id

Line 2866: FROM gl_code_combinations glcc,

2862: jlcgt.period_num pernum,
2863: glcc.account_type acctype,
2864: sum(nvl(jlcgt.accounted_dr,0)) acc_dr, --bug 10207969
2865: sum(nvl(jlcgt.accounted_cr,0)) acc_cr --bug 10207969
2866: FROM gl_code_combinations glcc,
2867: jl_co_gl_trx jlcgt
2868: WHERE process_id = p_rcid
2869: AND jlcgt.code_combination_id = glcc.code_combination_id
2870: GROUP BY jlcgt.set_of_books_id,