DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_CODE_COMBINATIONS

Line 73: gl_code_combinations glcc,

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

Line 1781: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt

1777: jlcgt.period_num pernum,
1778: glcc.account_type acctype,
1779: NVL(sum(jlcgt.accounted_dr),0) acc_dr,
1780: NVL(sum(jlcgt.accounted_cr),0) acc_cr
1781: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
1782: WHERE jlcgt.process_id IN ( SELECT process_id
1783: FROM jl_co_gl_conc_ctrl
1784: WHERE NVL(balance_calculated,'N') <> 'Y'
1785: AND set_of_books_id

Line 2006: FROM gl_code_combinations glcc,

2002: jlcgt.period_num pernum,
2003: glcc.account_type acctype,
2004: NVL(sum(jlcgt.accounted_dr),0) acc_dr,
2005: NVL(sum(jlcgt.accounted_cr),0) acc_cr
2006: FROM gl_code_combinations glcc,
2007: jl_co_gl_trx jlcgt
2008: WHERE process_id = p_rcid
2009: AND jlcgt.code_combination_id = glcc.code_combination_id
2010: GROUP BY jlcgt.set_of_books_id,