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 1369: (p_msg => 'SQL - Select from gl_code_combinations '

1365:
1366: BEGIN
1367: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1368: trace
1369: (p_msg => 'SQL - Select from gl_code_combinations '
1370: ,p_level => C_LEVEL_STATEMENT
1371: ,p_module => l_log_module);
1372: END IF;
1373:

Line 1446: FROM gl_code_combinations gcc

1442: , g_array_combination_id(l_position).segment28
1443: , g_array_combination_id(l_position).segment29
1444: , g_array_combination_id(l_position).segment30
1445: , g_array_combination_id(l_position).combination_status
1446: FROM gl_code_combinations gcc
1447: WHERE gcc.code_combination_id = p_combination_id
1448: AND gcc.chart_of_accounts_id = l_id_flex_num
1449: AND gcc.template_id IS NULL
1450: ;

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

2872: | |
2873: | GetCcid |
2874: | |
2875: | Call AOL routine to create the new ccid, when the ccid does |
2876: | not exist in the gl_code_combinations table. It calls the |
2877: | AOL API FND_FLEX_EXT.get_combination_id. |
2878: | |
2879: +-------------------------------------------------------------*/
2880:

Line 3150: FROM gl_code_combinations gl

3146: AND temp.code_combination_id <> -1
3147: AND temp.balance_type_code <> 'X'
3148: AND NOT EXISTS
3149: (SELECT 'x'
3150: FROM gl_code_combinations gl
3151: WHERE gl.code_combination_id = temp.code_combination_id
3152: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3153: AND gl.template_id IS NULL)
3154: THEN C_INVALID

Line 3165: FROM gl_code_combinations gl

3161: AND temp.alt_code_combination_id <> -1
3162: AND temp.balance_type_code <> 'X'
3163: AND NOT EXISTS
3164: (SELECT 'x'
3165: FROM gl_code_combinations gl
3166: WHERE gl.code_combination_id = temp.alt_code_combination_id
3167: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3168: AND gl.template_id IS NULL)
3169: THEN C_INVALID

Line 3178: FROM gl_code_combinations gl

3174: AND temp.code_combination_status_code = C_NOT_PROCESSED
3175: AND temp.code_combination_id <> -1
3176: AND temp.balance_type_code <> 'X'
3177: AND NOT EXISTS (SELECT 'x'
3178: FROM gl_code_combinations gl
3179: WHERE gl.code_combination_id = temp.code_combination_id
3180: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3181: AND gl.template_id IS NULL
3182: ))

Line 3189: FROM gl_code_combinations gl

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

Line 3411: FROM gl_code_combinations gl

3407: , nvl(temp.segment28 , gl.segment28)
3408: , nvl(temp.segment29 , gl.segment29)
3409: , nvl(temp.segment30 , gl.segment30)
3410: , C_PROCESSING
3411: FROM gl_code_combinations gl
3412: WHERE gl.code_combination_id = temp.code_combination_id
3413: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3414: AND gl.template_id IS NULL
3415: )

Line 3506: FROM gl_code_combinations gl

3502: , nvl(temp.alt_segment28 , gl.segment28)
3503: , nvl(temp.alt_segment29 , gl.segment29)
3504: , nvl(temp.alt_segment30 , gl.segment30)
3505: , C_PROCESSING
3506: FROM gl_code_combinations gl
3507: WHERE gl.code_combination_id = temp.alt_code_combination_id
3508: AND gl.chart_of_accounts_id = temp.ccid_coa_id
3509: AND gl.template_id IS NULL
3510: )

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

3553: | Private function |
3554: | |
3555: | create_ccid |
3556: | |
3557: | retrieves new accounting ccids and ALT ccids from gl_code_combinations |
3558: | gl_code_combinations table. It returns the number of rows updated |
3559: | |
3560: +-----------------------------------------------------------------------*/
3561:

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

3554: | |
3555: | create_ccid |
3556: | |
3557: | retrieves new accounting ccids and ALT ccids from gl_code_combinations |
3558: | gl_code_combinations table. It returns the number of rows updated |
3559: | |
3560: +-----------------------------------------------------------------------*/
3561:
3562: FUNCTION create_ccid

Line 3732: FROM gl_code_combinations glc

3728: AND temp.code_combination_status_code = :2
3729: AND temp.balance_type_code <> ''X''
3730: THEN
3731: (SELECT glc.code_combination_id
3732: FROM gl_code_combinations glc
3733: WHERE glc.chart_of_accounts_id = temp.ccid_coa_id
3734: AND temp.ccid_coa_id = :3
3735: AND glc.template_id IS NULL
3736: ' || l_sql_stmt || ' )

Line 3756: FROM gl_code_combinations glc

3752: AND temp.alt_ccid_status_code = :8
3753: AND temp.balance_type_code <> ''X''
3754: THEN
3755: (SELECT glc.code_combination_id
3756: FROM gl_code_combinations glc
3757: WHERE glc.chart_of_accounts_id = temp.ccid_coa_id
3758: AND temp.ccid_coa_id = :9
3759: AND glc.template_id IS NULL
3760: ' || l_alt_sql_stmt || ' )

Line 4498: FROM gl_code_combinations gami

4494: , l_array_processing_status_code
4495: , l_array_to_segment_code
4496: , l_array_ccid
4497: , l_array_segment_value
4498: FROM gl_code_combinations gami
4499: , xla_transaction_accts_gt xta
4500: WHERE gami.code_combination_id = xta.code_combination_id
4501: AND gami.chart_of_accounts_id = l_from_coa_id
4502: AND xta.code_combination_id IS NOT NULL

Line 4948: FROM gl_code_combinations_kfv

4944:
4945: --added bug 6666983,account value should be displayed in error message even if ccid is invalid
4946: SELECT concatenated_segments
4947: INTO l_ConcatKey
4948: FROM gl_code_combinations_kfv
4949: WHERE code_combination_id = error_rec.from_ccid;
4950:
4951:
4952: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;