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.XLA_AE_CODE_COMBINATION_PKG dependencies on GL_CODE_COMBINATIONS

Line 1376: (p_msg => 'SQL - Select from gl_code_combinations '

1372:
1373: BEGIN
1374: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1375: trace
1376: (p_msg => 'SQL - Select from gl_code_combinations '
1377: ,p_level => C_LEVEL_STATEMENT
1378: ,p_module => l_log_module);
1379: END IF;
1380:

Line 1453: FROM gl_code_combinations gcc

1449: , g_array_combination_id(l_position).segment28
1450: , g_array_combination_id(l_position).segment29
1451: , g_array_combination_id(l_position).segment30
1452: , g_array_combination_id(l_position).combination_status
1453: FROM gl_code_combinations gcc
1454: WHERE gcc.code_combination_id = p_combination_id
1455: AND gcc.chart_of_accounts_id = l_id_flex_num
1456: AND gcc.template_id IS NULL
1457: ;

Line 2886: | not exist in the gl_code_combinations table. It calls the |

2882: | |
2883: | GetCcid |
2884: | |
2885: | Call AOL routine to create the new ccid, when the ccid does |
2886: | not exist in the gl_code_combinations table. It calls the |
2887: | AOL API FND_FLEX_EXT.get_combination_id. |
2888: | |
2889: +-------------------------------------------------------------*/
2890:

Line 3160: FROM gl_code_combinations gl

3156: AND temp.code_combination_id <> -1
3157: AND temp.balance_type_code <> 'X'
3158: AND NOT EXISTS
3159: (SELECT 'x'
3160: FROM gl_code_combinations gl
3161: WHERE gl.code_combination_id = temp.code_combination_id
3162: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3163: AND gl.template_id IS NULL)
3164: THEN C_INVALID

Line 3175: FROM gl_code_combinations gl

3171: AND temp.alt_code_combination_id <> -1
3172: AND temp.balance_type_code <> 'X'
3173: AND NOT EXISTS
3174: (SELECT 'x'
3175: FROM gl_code_combinations gl
3176: WHERE gl.code_combination_id = temp.alt_code_combination_id
3177: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3178: AND gl.template_id IS NULL)
3179: THEN C_INVALID

Line 3188: FROM gl_code_combinations gl

3184: AND temp.code_combination_status_code = C_NOT_PROCESSED
3185: AND temp.code_combination_id <> -1
3186: AND temp.balance_type_code <> 'X'
3187: AND NOT EXISTS (SELECT 'x'
3188: FROM gl_code_combinations gl
3189: WHERE gl.code_combination_id = temp.code_combination_id
3190: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3191: AND gl.template_id IS NULL
3192: ))

Line 3199: FROM gl_code_combinations gl

3195: AND temp.alt_ccid_status_code = C_NOT_PROCESSED
3196: AND temp.alt_code_combination_id <> -1
3197: AND temp.balance_type_code <> 'X'
3198: AND NOT EXISTS (SELECT 'x'
3199: FROM gl_code_combinations gl
3200: WHERE gl.code_combination_id = temp.alt_code_combination_id
3201: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3202: AND gl.template_id IS NULL
3203: ))

Line 3421: FROM gl_code_combinations gl

3417: , nvl(temp.segment28 , gl.segment28)
3418: , nvl(temp.segment29 , gl.segment29)
3419: , nvl(temp.segment30 , gl.segment30)
3420: , C_PROCESSING
3421: FROM gl_code_combinations gl
3422: WHERE gl.code_combination_id = temp.code_combination_id
3423: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3424: AND gl.template_id IS NULL
3425: )

Line 3516: FROM gl_code_combinations gl

3512: , nvl(temp.alt_segment28 , gl.segment28)
3513: , nvl(temp.alt_segment29 , gl.segment29)
3514: , nvl(temp.alt_segment30 , gl.segment30)
3515: , C_PROCESSING
3516: FROM gl_code_combinations gl
3517: WHERE gl.code_combination_id = temp.alt_code_combination_id
3518: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3519: AND gl.template_id IS NULL
3520: )

Line 3567: | retrieves new accounting ccids and ALT ccids from gl_code_combinations |

3563: | Private function |
3564: | |
3565: | create_ccid |
3566: | |
3567: | retrieves new accounting ccids and ALT ccids from gl_code_combinations |
3568: | gl_code_combinations table. It returns the number of rows updated |
3569: | |
3570: +-----------------------------------------------------------------------*/
3571:

Line 3568: | gl_code_combinations table. It returns the number of rows updated |

3564: | |
3565: | create_ccid |
3566: | |
3567: | retrieves new accounting ccids and ALT ccids from gl_code_combinations |
3568: | gl_code_combinations table. It returns the number of rows updated |
3569: | |
3570: +-----------------------------------------------------------------------*/
3571:
3572: FUNCTION create_ccid

Line 3742: FROM gl_code_combinations glc

3738: AND temp.code_combination_status_code = :2
3739: AND temp.balance_type_code <> ''X''
3740: THEN
3741: (SELECT glc.code_combination_id
3742: FROM gl_code_combinations glc
3743: WHERE glc.chart_of_accounts_id = temp.ccid_coa_id
3744: AND temp.ccid_coa_id = :3
3745: AND glc.template_id IS NULL
3746: ' || l_sql_stmt || ' )

Line 3766: FROM gl_code_combinations glc

3762: AND temp.alt_ccid_status_code = :8
3763: AND temp.balance_type_code <> ''X''
3764: THEN
3765: (SELECT glc.code_combination_id
3766: FROM gl_code_combinations glc
3767: WHERE glc.chart_of_accounts_id = temp.ccid_coa_id
3768: AND temp.ccid_coa_id = :9
3769: AND glc.template_id IS NULL
3770: ' || l_alt_sql_stmt || ' )

Line 4512: FROM gl_code_combinations gami

4508: , l_array_processing_status_code
4509: , l_array_to_segment_code
4510: , l_array_ccid
4511: , l_array_segment_value
4512: FROM gl_code_combinations gami
4513: , xla_transaction_accts_gt xta
4514: WHERE gami.code_combination_id = xta.code_combination_id
4515: AND gami.chart_of_accounts_id = l_from_coa_id
4516: AND xta.code_combination_id IS NOT NULL

Line 4962: FROM gl_code_combinations_kfv

4958: /*
4959: --added bug 6666983,account value should be displayed in error message even if ccid is invalid
4960: SELECT concatenated_segments
4961: INTO l_ConcatKey
4962: FROM gl_code_combinations_kfv
4963: WHERE code_combination_id = error_rec.from_ccid;
4964: */ --commented per bug 8687228
4965:
4966: