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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 244: CURSOR bsv_cur IS SELECT jg_info_v1 from jg_zz_vat_trx_gt; -- jg_zz_vat_trx_gt is global temparary table to store the BSVs associated to LE or Establishment.

240: l_bsv_count NUMBER;
241: l_le_count NUMBER;
242: l_fsg_output_check VARCHAR2(100);
243:
244: CURSOR bsv_cur IS SELECT jg_info_v1 from jg_zz_vat_trx_gt; -- jg_zz_vat_trx_gt is global temparary table to store the BSVs associated to LE or Establishment.
245:
246: /* Cursor used to find the position of account and sped qualifiers */
247: CURSOR pos_qualifier_cur(p_flex_value_set_id NUMBER) IS
248: SELECT rownum,

Line 450: for filtering and storing in a gt table(jg_zz_vat_trx_gt) */

446: return;
447: END;
448:
449: IF l_exclusive_mode ='N' THEN /* If not exclusive mode deriving the BSVs attached to either LE or Establishment
450: for filtering and storing in a gt table(jg_zz_vat_trx_gt) */
451:
452: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
453: jg_info_v1)
454: SELECT g_concurrent_request_id,

Line 452: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,

448:
449: IF l_exclusive_mode ='N' THEN /* If not exclusive mode deriving the BSVs attached to either LE or Establishment
450: for filtering and storing in a gt table(jg_zz_vat_trx_gt) */
451:
452: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
453: jg_info_v1)
454: SELECT g_concurrent_request_id,
455: segment_value
456: FROM GL_LEDGER_NORM_SEG_VALS

Line 3273: OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

3269: AND jh.status = ''P''
3270: AND jl.status = ''P''
3271: AND jh.default_effective_date between '''||g_start_date||''' and '''|| g_end_date||'''
3272: AND ('''||l_exclusive_mode||'''=''Y''
3273: OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
3274: GROUP BY glimp.je_header_id,glimp.je_line_num,jl.code_combination_id,glcc.'||g_account_segment||'
3275: HAVING count(*) >1)';
3276:
3277:

Line 3818: ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

3814: FROM gl_code_combinations glcc
3815: WHERE glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||
3816: ' AND glcc.summary_flag = ''N''
3817: AND ('''||l_exclusive_mode||'''=''Y'' OR
3818: ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
3819: AND glcc.'||g_account_segment||' =V.child_flex_value
3820: )
3821: CONNECT BY V.parent_flex_value = PRIOR V.child_flex_value
3822: START WITH V.parent_flex_value IN

Line 4450: OR ('''||l_exclusive_mode ||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

4446: FROM gl_code_combinations glcc
4447: WHERE glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||
4448: ' AND glcc.summary_flag = ''N''
4449: AND ('''||l_exclusive_mode||'''=''Y''
4450: OR ('''||l_exclusive_mode ||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
4451: AND glcc.'||g_cost_center_segment||' =fv.flex_value)';
4452:
4453: -- fnd_file.put_line(fnd_file.log,l_query);
4454:

Line 4717: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt))) AND glcc.summary_flag = ''N''

4713: WHERE period_name in('''||g_period_name||''' , '''||g_adjustment_period_name||''')
4714: AND glb.ledger_id = '||g_ledger_id||
4715: ' AND glb.currency_code = '''||g_currency_code||'''
4716: AND glb.code_combination_id= glcc.code_combination_id
4717: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt))) AND glcc.summary_flag = ''N''
4718: AND glb.actual_flag = ''A''
4719: GROUP BY glcc.'||g_account_segment||',decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment ||')
4720: HAVING NVL(SUM(DECODE(glb.period_name
4721: ,'''||g_period_name||''',BEGIN_BALANCE_DR - BEGIN_BALANCE_CR,0)),0) <> 0 OR

Line 4841: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

4837: WHERE period_name in('''||g_period_name||''' , '''||g_adjustment_period_name||''')
4838: AND glb.ledger_id = '||g_ledger_id||
4839: ' AND glb.currency_code = '''||g_currency_code||'''
4840: AND glb.code_combination_id= glcc.code_combination_id
4841: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
4842: AND glcc.summary_flag = ''N''
4843: AND glb.actual_flag = ''A''
4844: GROUP BY glcc.'||g_account_segment||',decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment ||')
4845: HAVING NVL(SUM(DECODE(glb.period_name

Line 4915: (l_exclusive_mode = 'N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (select jg_info_v1 from jg_zz_vat_trx_gt)))

4911: FROM gl_je_lines jl
4912: WHERE jl.je_header_id= j.je_header_id
4913: AND jl.ledger_id=g_ledger_id
4914: AND (l_exclusive_mode = 'Y' OR
4915: (l_exclusive_mode = 'N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (select jg_info_v1 from jg_zz_vat_trx_gt)))
4916: );
4917:
4918: BEGIN
4919:

Line 5098: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify

5094: FROM gl_je_lines jl
5095: WHERE jl.je_header_id = p_journal_header_id
5096: AND jl.accounted_dr is not null
5097: AND jl.ledger_id = g_ledger_id
5098: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify
5099:
5100:
5101: -- Credit Lines
5102:

Line 5161: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify

5157: FROM gl_je_lines jl
5158: WHERE jl.je_header_id = p_journal_header_id
5159: AND jl.accounted_cr is not null
5160: AND jl.ledger_id = g_ledger_id
5161: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(jl.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 FROM jg_zz_vat_trx_gt))); -- need to modify
5162:
5163:
5164: EXCEPTION
5165: WHEN OTHERS THEN

Line 5246: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(xll.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 from jg_zz_vat_trx_gt))); --- Need to modify

5242: AND xll.application_id = xld.application_id
5243: AND xlh.EVENT_ID = xld.EVENT_ID
5244: AND xll.ae_line_num = xld.ae_line_num --p_je_line_num
5245: AND xld.UNROUNDED_ACCOUNTED_DR IS NOT NULL
5246: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(xll.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 from jg_zz_vat_trx_gt))); --- Need to modify
5247:
5248: -- inserts credit lines. added as part of ER#11653651
5249: INSERT INTO jl_br_sped_extr_data_t
5250: (request_id,

Line 5318: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(xll.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 from jg_zz_vat_trx_gt))); --- Need to modify

5314: AND xll.application_id = xld.application_id
5315: AND xlh.EVENT_ID = xld.EVENT_ID
5316: AND xll.ae_line_num = xld.ae_line_num --p_je_line_num
5317: AND xld.UNROUNDED_ACCOUNTED_CR IS NOT NULL
5318: AND (l_exclusive_mode='Y' OR (l_exclusive_mode='N' AND get_segment_value(xll.code_combination_id,g_bsv_segment) in (SELECT jg_info_v1 from jg_zz_vat_trx_gt))); --- Need to modify
5319:
5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5385: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

5381: AND jh.status = ''P''
5382: AND jh.currency_code <> ''STAT'' -- filtering statistic journals. Introduced thid condition for new sped enhancement
5383: AND glcc.code_combination_id = jl.code_combination_id
5384: AND glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||'
5385: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
5386: GROUP BY jl.effective_date
5387: ,glcc.'||g_account_segment||'
5388: ,decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment||')
5389: ORDER BY jl.effective_date

Line 5643: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))

5639: ' AND glcc.account_type in (''E'',''R'')
5640: AND glcc.summary_flag = ''N''
5641: AND glb.actual_flag = ''A''
5642: AND glb.currency_code = '''||g_currency_code||'''
5643: AND ('''||l_exclusive_mode||'''=''Y'' OR ('''||l_exclusive_mode||'''=''N'' AND glcc.'||g_bsv_segment||' in (select jg_info_v1 from jg_zz_vat_trx_gt)))
5644: GROUP BY glcc.'||g_account_segment||',decode('||l_cc_exists_flag||',0,null,glcc.'||g_cost_center_segment||')
5645: HAVING sum(((glb.BEGIN_BALANCE_DR - glb.BEGIN_BALANCE_CR)
5646: + (glb.PERIOD_NET_DR - glb.PERIOD_NET_CR)))<>0) ';
5647: