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

Line 31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;

27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 32: v_account gl_code_combinations.segment1%TYPE;

28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 33: v_fund gl_code_combinations.segment1%TYPE;

29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;

137: --
138: v_balance_column_name fnd_id_flex_segments.application_column_name%TYPE;
139: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
140: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
141: c_sbr_ts_value gl_code_combinations.segment1%TYPE;
142: c_sbr_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
143: c_sbr_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
144: c_sbr_prev_line_number fv_sbr_definitions_lines.sbr_line_number%TYPE;
145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;

Line 838: ' from gl_code_combinations WHERE ' ||v_acc_seg_name || 'like '':b_account_number%'''' and template_id is null and '

834: v_insert_statement := 'insert into fv_sbr_ccids_gt(
835: sbr_line_acct_id,
836: ccid)
837: select ' || sbr_crec_rec.sbr_line_acct_id || ', code_combination_id ' ||
838: ' from gl_code_combinations WHERE ' ||v_acc_seg_name || 'like '':b_account_number%'''' and template_id is null and '
839: || ' chart_of_accounts_id = :B_CHART_OF_ACCOUNTS_ID
840: and not exists (select code_combination_id
841: from fv_sbr_ccids_gt FCT ' || 'where fct.detail_id = :b_line_detail_id '|| ')';
842: EXECUTE immediate v_insert_statement USING V_CHART_OF_ACCOUNTS_ID,

Line 941: || ' from gl_code_combinations WHERE ' || v_statement || ' and

937: v_insert_statement := 'insert into FV_CCID_CFS_GT(
938: detail_id,
939: ccid)
940: select ' || crec_rec.line_detail_id || ', code_combination_id '
941: || ' from gl_code_combinations WHERE ' || v_statement || ' and
942: template_id is null and ' || ' chart_of_accounts_id = :B_CHART_OF_ACCOUNTS_ID
943: and not exists (select code_combination_id
944: from fv_ccid_CFS_GT FCT ' || 'where fct.detail_id = :b_line_detail_id '|| ')';
945:

Line 1076: gl_code_combinations glc,

1072: (NVL(glbal.period_net_dr,0) -
1073: NVL(glbal.period_net_cr,0))),0),2)),0)
1074: FROM fv_cfs_rep_line_dtl dets,
1075: fv_ccid_cfs_gt fvcc,
1076: gl_code_combinations glc,
1077: gl_balances glbal
1078: WHERE dets.line_id = :cv_line_id
1079: AND dets.line_detail_id = :cv_line_detail_id
1080: AND dets.line_detail_id = fvcc.detail_id

Line 1458: l_account_number gl_code_combinations.segment1%TYPE;

1454: l_log_mesg VARCHAR2(32000) := '';
1455: l_conc_segs VARCHAR2(32000);
1456: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1457: l_account_type VARCHAR2(1) := '';
1458: l_account_number gl_code_combinations.segment1%TYPE;
1459: l_balance_determined NUMBER;
1460: l_prev_year_gl_balance NUMBER;
1461: l_curr_year_gl_balance NUMBER;
1462: l_e_ne_ind fv_facts_attributes.exch_non_exch%TYPE := NULL;

Line 3691: gl_code_combinations glc,

3687: (NVL(glbal.period_net_dr,0) -
3688: NVL(glbal.period_net_cr,0))),0),2)),0)
3689: FROM fv_sbr_definitions_accts dets,
3690: fv_sbr_definitions_lines fsdl ,
3691: gl_code_combinations glc,
3692: gl_code_combinations glc1,
3693: gl_balances glbal
3694: WHERE dets.sbr_line_id = :cv_line_id
3695: AND dets.sbr_line_acct_id = :cv_line_detail_id

Line 3692: gl_code_combinations glc1,

3688: NVL(glbal.period_net_cr,0))),0),2)),0)
3689: FROM fv_sbr_definitions_accts dets,
3690: fv_sbr_definitions_lines fsdl ,
3691: gl_code_combinations glc,
3692: gl_code_combinations glc1,
3693: gl_balances glbal
3694: WHERE dets.sbr_line_id = :cv_line_id
3695: AND dets.sbr_line_acct_id = :cv_line_detail_id
3696: AND dets.sbr_line_id = fsdl.sbr_line_id

Line 3775: l_account_number gl_code_combinations.segment1%TYPE;

3771: l_log_mesg VARCHAR2(32000) := '';
3772: l_conc_segs VARCHAR2(32000);
3773: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
3774: l_account_type VARCHAR2(1) := '';
3775: l_account_number gl_code_combinations.segment1%TYPE;
3776: l_balance_determined NUMBER;
3777: l_prev_year_gl_balance NUMBER;
3778: l_curr_year_gl_balance NUMBER;
3779: l_e_ne_ind fv_facts_attributes.exch_non_exch%TYPE := NULL;