APPS.FII_GL_CCID_C dependencies on GL_CODE_COMBINATIONS

Line 324: FROM GL_CODE_COMBINATIONS

320: SELECT DISTINCT
321: CHART_OF_ACCOUNTS_ID,
322: ' || l_company_seg || ',
323: -2
324: FROM GL_CODE_COMBINATIONS
325: WHERE CHART_OF_ACCOUNTS_ID = ' || l_coa_id || '
326: AND SUMMARY_FLAG = ''N''
327: AND TEMPLATE_ID IS NULL ';
328:

Line 444: GL_CODE_COMBINATIONS glcc,

440: FII_CCID_SLG_GT csg,
441: fnd_id_flex_segments seg1,
442: fnd_id_flex_segments seg2,
443: fnd_id_flex_segments seg3,
444: GL_CODE_COMBINATIONS glcc,
445: fnd_flex_values flx1,
446: fnd_flex_values flx2,
447: fnd_flex_values flx3 ';
448:

Line 622: GL_CODE_COMBINATIONS glcc,

618: FII_CCID_SLG_GT csg,
619: fnd_id_flex_segments seg1,
620: fnd_id_flex_segments seg2,
621: fnd_id_flex_segments seg3,
622: GL_CODE_COMBINATIONS glcc,
623: fnd_flex_values flx1,
624: fnd_flex_values flx2,
625: fnd_flex_values flx3 ';
626:

Line 741: -- Note that origianl g_new_max_ccid is from GL_CODE_COMBINATIONS,

737: -- may not necessary be the largest CCID that was inserted.
738: -- New ccids could have been created while the program is
739: -- running. So record this max ccid from fii_gl_ccid_dimensions
740: --
741: -- Note that origianl g_new_max_ccid is from GL_CODE_COMBINATIONS,
742: --------------------------------------------------------------
743:
744: g_phase := 'SELECT FROM fii_gl_ccid_dimensions';
745:

Line 825: FROM gl_code_combinations;

821: FII_UTIL.Write_Log('');
822: End if;
823:
824: SELECT max(code_combination_id) INTO g_new_max_ccid
825: FROM gl_code_combinations;
826:
827: If g_debug_flag = 'Y' then
828: FII_MESSAGE.Func_Succ('FII_GL_CCID_C.NEW_CCID_IN_GL');
829: End if;

Line 873: FROM gl_code_combinations gcc

869:
870: UPDATE fii_gl_ccid_dimensions dim
871: SET dim.company_cost_center_org_id =
872: (SELECT NVL(gcc.company_cost_center_org_id, -1)
873: FROM gl_code_combinations gcc
874: WHERE gcc.code_combination_id = dim.code_combination_id)
875: WHERE dim.company_cost_center_org_id = -1;
876:
877: IF g_debug_flag = 'Y' then

Line 983: g_phase := 'SELECT FROM gl_code_combinations';

979: g_max_ccid := 0;
980:
981: END IF;
982:
983: g_phase := 'SELECT FROM gl_code_combinations';
984:
985: SELECT max(code_combination_id) INTO g_new_max_ccid
986: FROM gl_code_combinations;
987:

Line 986: FROM gl_code_combinations;

982:
983: g_phase := 'SELECT FROM gl_code_combinations';
984:
985: SELECT max(code_combination_id) INTO g_new_max_ccid
986: FROM gl_code_combinations;
987:
988: IF (g_new_max_ccid > g_max_ccid) THEN
989:
990: g_phase := 'Insert new CCIDs into FII_GL_CCID_DIMENSIONS table';

Line 1205: FROM gl_code_combinations glccd,

1201: -----------------------------------------------------
1202: l_stmt := 'UPDATE fii_gl_ccid_dimensions glcc
1203: SET (glcc.product_id, glcc.PROD_CATEGORY_ID) =
1204: (SELECT flx1.flex_value_id, mtc.category_id
1205: FROM gl_code_combinations glccd,
1206: mtl_categories mtc,
1207: fnd_id_flex_segments seg1,
1208: fnd_flex_values flx1
1209: WHERE glccd.code_combination_id = glcc.code_combination_id

Line 1310: FROM gl_code_combinations glcc,

1306: ' ||g_fii_user_id || ',
1307: sysdate,
1308: ' || g_fii_user_id || ',
1309: ' || g_fii_login_id || '
1310: FROM gl_code_combinations glcc,
1311: fii_product_assignments fipa
1312: WHERE glcc.chart_of_accounts_id = :p_coa_id
1313: AND fipa.chart_of_accounts_id = glcc.chart_of_accounts_id
1314: AND fipa.PROD_CATEGORY_SET_ID = :G_PROD_CAT_SET_ID