DBA Data[Home] [Help]

APPS.JA_CN_UDRV_EXPORT dependencies on GL_LEDGERS

Line 112: , gl_ledgers gl, gl_periods gp

108: 'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
109: , ffvt.description
110: FROM
111: ja_cn_journal_lines jcjl
112: , gl_ledgers gl, gl_periods gp
113: , fnd_flex_values_tl ffvt
114: , fnd_flex_values ffv
115: , fnd_id_flex_segments fifs
116: , ja_cn_voucher_number jcvn

Line 178: , gl_ledgers gl

174: 'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
175: , ppa.name,ppa.description
176: FROM
177: ja_cn_journal_lines jcjl
178: , gl_ledgers gl
179: , gl_periods gp
180: , pa_projects_all ppa
181: , ja_cn_voucher_number jcvn
182: WHERE gl.ledger_id = pn_ledger_id

Line 247: gl_ledgers gl,

243: SELECT count(*)
244: INTO ln_journal_number
245: FROM (SELECT DISTINCT * --Add by Jianchao Chi, 10-Jan-2011, for one hearder may has two same
246: FROM ja_cn_journal_lines jl, --line numbers in ja_cn_journal_lines.
247: gl_ledgers gl,
248: gl_periods gp,
249: ja_cn_voucher_number jcvn
250: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
251: --Add ja_cn_voucher_number table, voucher number and legal entity