APPS.FV_FACTS_TBAL_TRX dependencies on GL_CODE_COMBINATIONS

Line 125: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;

121: v_catb_prg_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
122: v_prn_prg_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
123: v_cohort_select Varchar2(20) ;
124: v_cohort_where Varchar2(120) ;
125: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
126: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
127: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
128: v_ccid number;
129: vl_ccid number;

Line 158: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;

154: v_fund_count number(3);
155: vg_amount NUMBER;
156: v_dummy_cohort VARCHAR2(25);
157: v_vl_main_cursor_found varchar2(1) := 'N' ;
158: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
159: v_period_activity NUMBER;
160:
161: v_facts_attributes_setup BOOLEAN ;
162:

Line 769: GL_CODE_COMBINATIONS GLCC

765: (glb.period_net_dr - period_net_cr)) '||
766: v_segment ||
767: v_cohort_select ||
768: ' From GL_BALANCES GLB,
769: GL_CODE_COMBINATIONS GLCC
770: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
771:
772: -- Data Access Security
773: das_id := fnd_profile.value('GL_ACCESS_SET_ID');

Line 1222: gl_code_combinations glcc,

1218: gjh.je_source ,gjh.je_header_id , gjl.je_line_num , gjh.je_batch_id,je_from_sla_flag '||
1219: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1220: va_advance_type_col ||
1221: ' From gl_je_lines gjl,
1222: gl_code_combinations glcc,
1223: gl_je_headers gjh
1224: Where gjl.code_combination_id = glcc.code_combination_id
1225: AND glcc.code_combination_id = :ccid ';
1226:

Line 2255: GL_CODE_COMBINATIONS GLCC

2251: GLB.BEGIN_BALANCE_CR) + (GLB.PERIOD_NET_DR - PERIOD_NET_CR ))),0),
2252: SUM(glb.period_net_dr - glb.period_net_cr) ,
2253: SUM(glb.period_net_dr) , sum(glb.period_net_cr)
2254: From GL_BALANCES GLB,
2255: GL_CODE_COMBINATIONS GLCC
2256: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
2257:
2258: -- Data Access Security
2259: das_id := fnd_profile.value('GL_ACCESS_SET_ID');

Line 2902: GL_CODE_COMBINATIONS GLCC

2898: ' SUM(GLB.PERIOD_NET_DR - PERIOD_NET_CR ), '||
2899: ' SUM(GLB.PERIOD_NET_DR) period_dr , sum( PERIOD_NET_CR ) period_cr '||
2900: v_cohort_select ||
2901: ' From GL_BALANCES GLB,
2902: GL_CODE_COMBINATIONS GLCC
2903: WHERE GLB.code_combination_id = GLCC.code_combination_id
2904: AND glcc.code_combination_id = :ccid
2905: AND glb.actual_flag = :actual_flag
2906: AND GLCC.'|| v_bal_seg_name ||' = :Fund_Value

Line 3068: ' From FV_FACTS_TEMP fvt, gl_code_combinations glcc

3064: SUM(AMOUNT1),
3065: SUM(AMOUNT2),
3066: SUM(decode(begin_end , ''P'' , 0 , period_activity )) '
3067: || vl_group_by ||
3068: ' From FV_FACTS_TEMP fvt, gl_code_combinations glcc
3069: WHERE fct_int_record_category = ''REPORTED''
3070: AND fct_int_record_type = ''TB''
3071: AND tbal_fund_value = ' || '''' || v_fund_value || ''''
3072: || ' and glcc.code_combination_id = fvt.code_combination_id