APPS.ARRX_COGS_REP_INNER dependencies on GL_CODE_COMBINATIONS

Line 73: FROM ar_cogs_rev_itf cgs, gl_code_combinations gcc

69: --
70: CURSOR getdesc IS
71: SELECT cgs.cogs_acct_description code_combination_id,
72: gcc.chart_of_accounts_id
73: FROM ar_cogs_rev_itf cgs, gl_code_combinations gcc
74: WHERE cgs.cogs_acct_description = gcc.code_combination_id;
75:
76: BEGIN
77:

Line 79: -- The description in gl_code_combinations is not the right one.

75:
76: BEGIN
77:
78: -- Bug # 3840430
79: -- The description in gl_code_combinations is not the right one.
80: -- To get the description we need to call the function
81: -- fnd_flex_keyval.concatenated_descriptions however this will only
82: -- work if the cc id was validated just before that. To do that
83: -- we need the code_combination_id which is not stored in the

Line 264: gl_code_combinations gcc,

260: hz_cust_accounts acct,
261: hz_parties party,
262: mtl_system_items_b msi,
263: ra_cust_trx_types trx_type,
264: gl_code_combinations gcc,
265: cst_item_costs cic,
266: mtl_parameters mp
267: WHERE dist.customer_trx_line_id = lines.customer_trx_line_id
268: AND dist.account_set_flag = 'N'

Line 398: l_cc_id_low gl_code_combinations.code_combination_id%TYPE;

394: x_retcode OUT NOCOPY NUMBER,
395: x_errbuf OUT NOCOPY VARCHAR2) IS
396:
397: l_precision fnd_currencies.precision%TYPE;
398: l_cc_id_low gl_code_combinations.code_combination_id%TYPE;
399: l_cc_id_high gl_code_combinations.code_combination_id%TYPE;
400:
401: l_gl_acct_tbl varchar_table;
402: l_gl_acct_desc_tbl varchar_table;

Line 399: l_cc_id_high gl_code_combinations.code_combination_id%TYPE;

395: x_errbuf OUT NOCOPY VARCHAR2) IS
396:
397: l_precision fnd_currencies.precision%TYPE;
398: l_cc_id_low gl_code_combinations.code_combination_id%TYPE;
399: l_cc_id_high gl_code_combinations.code_combination_id%TYPE;
400:
401: l_gl_acct_tbl varchar_table;
402: l_gl_acct_desc_tbl varchar_table;
403: l_cogs_adjustment_tbl number_table;