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_TB_AP_REPORT_PVT dependencies on XLA_TRIAL_BALANCES_GT

Line 70: FROM xla_trial_balances_gt tbg

66: ,tbg.user_trx_identifier_value_10 USER_TRX_IDENTIFIER_VALUE_10
67: ,tbg.NON_AP_AMOUNT NON_AP_AMOUNT
68: ,tbg.MANUAL_SLA_AMOUNT MANUAL_SLA_AMOUNT
69: $seg_desc_cols$
70: FROM xla_trial_balances_gt tbg
71: ,fnd_application_vl app
72: ,xla_entity_types_vl ett
73: ,gl_code_combinations_kfv gcck
74: ,gl_balances gb

Line 340: FROM xla_trial_balances_gt tbg

336: ,tbg.user_trx_identifier_value_10 USER_TRX_IDENTIFIER_VALUE_10
337: ,tbg.NON_AP_AMOUNT NON_AP_AMOUNT
338: ,tbg.MANUAL_SLA_AMOUNT MANUAL_SLA_AMOUNT
339: $seg_desc_cols$
340: FROM xla_trial_balances_gt tbg
341: ,fnd_application_vl app
342: ,gl_code_combinations_kfv gcck
343: ,gl_balances gb
344: $seg_desc_from$

Line 356: INSERT INTO xla_trial_balances_gt

352: ';
353:
354: -- Perf changes for TB Report Summary Template bug:8773522 --
355: C_INSERT_GT_SUMMARY_STATEMENT CONSTANT VARCHAR2(32000) := '
356: INSERT INTO xla_trial_balances_gt
357: (definition_code
358: ,ledger_id
359: ,ledger_name
360: ,ledger_short_name

Line 516: FROM xla_trial_balances_gt tbg

512: ,tbg.acctd_rounded_rem_amount SUM_SRC_ACCTD_ROUNDED_REM_AMT
513: ,tbg.NON_AP_AMOUNT NON_AP_AMOUNT
514: ,tbg.MANUAL_SLA_AMOUNT MANUAL_SLA_AMOUNT
515: $seg_desc_cols$
516: FROM xla_trial_balances_gt tbg
517: ,fnd_application_vl app
518: ,gl_code_combinations_kfv gcck
519: ,gl_balances gb
520: $seg_desc_from$

Line 565: FROM xla_trial_balances_gt tbg

561: ,tbg.user_trx_identifier_value_7 APPLIED_TRX_IDENTIFIER_VAL_7
562: ,tbg.user_trx_identifier_value_8 APPLIED_TRX_IDENTIFIER_VAL_8
563: ,tbg.user_trx_identifier_value_9 APPLIED_TRX_IDENTIFIER_VAL_9
564: ,tbg.user_trx_identifier_value_10 APPLIED_TRX_IDENTIFIER_VAL_10
565: FROM xla_trial_balances_gt tbg
566: ,fnd_application_vl app
567: ,xla_entity_types_vl ett
568: WHERE tbg.source_entity_code = ett.entity_code
569: AND tbg.source_application_id = ett.application_id

Line 577: SELECT/+ index(tbg XLA_TRIAL_BALANCES_GT_N1)/

573: ';*/
574:
575:
576: C_TB_APPLIED_SQL CONSTANT VARCHAR2(32000) := '
577: SELECT/*+ index(tbg XLA_TRIAL_BALANCES_GT_N1)*/
578: tbg.third_party_name THIRD_PARTY_NAME
579: ,tbg.third_party_number THIRD_PARTY_NUMBER
580: ,tbg.third_party_type_code THIRD_PARTY_TYPE_CODE
581: ,tbg.third_party_type THIRD_PARTY_TYPE

Line 615: FROM xla_trial_balances_gt tbg

611: ,tbg.user_trx_identifier_value_7 APPLIED_TRX_IDENTIFIER_VAL_7
612: ,tbg.user_trx_identifier_value_8 APPLIED_TRX_IDENTIFIER_VAL_8
613: ,tbg.user_trx_identifier_value_9 APPLIED_TRX_IDENTIFIER_VAL_9
614: ,tbg.user_trx_identifier_value_10 APPLIED_TRX_IDENTIFIER_VAL_10
615: FROM xla_trial_balances_gt tbg
616: ,fnd_application_vl app
617: ,xla_entity_types_vl ett
618: WHERE tbg.source_entity_code = ett.entity_code
619: AND tbg.source_application_id = ett.application_id

Line 919: INSERT INTO xla_trial_balances_gt

915:
916: ';
917:
918: C_INSERT_GT_STATEMENT CONSTANT VARCHAR2(32000) := '
919: INSERT INTO xla_trial_balances_gt
920: (definition_code
921: ,ledger_id
922: ,ledger_name
923: ,ledger_short_name

Line 2108: | Populate trial balance to xla_trial_balances_GT. |

2104: | |
2105: | Populate_Trail_Balance_Gt |
2106: | |
2107: | |
2108: | Populate trial balance to xla_trial_balances_GT. |
2109: | |
2110: +======================================================================*/
2111: PROCEDURE populate_trial_balance_gt
2112: (p_defn_info IN xla_tb_data_manager_pvt.r_definition_info

Line 2961: UPDATE xla_trial_balances_gt

2957: trunc(p_start_date),
2958: trunc(p_as_of_date);
2959:
2960: FORALL i IN 1..arr_ccid.COUNT
2961: UPDATE xla_trial_balances_gt
2962: SET NON_AP_AMOUNT = arr_non_ap_amount(i)
2963: WHERE code_combination_id = arr_ccid(i)
2964: AND ledger_id = arr_ledgerid(i);
2965:

Line 2978: UPDATE xla_trial_balances_gt

2974: trunc(NVL(p_start_date,to_date('01-01-1950','DD-MM-YYYY'))),
2975: trunc(NVL(p_as_of_date,to_date('31-12-9999','DD-MM-YYYY')));
2976:
2977: FORALL i IN 1..arr_ccid.COUNT
2978: UPDATE xla_trial_balances_gt
2979: SET MANUAL_SLA_AMOUNT = arr_manual_sla_amount(i)
2980: WHERE code_combination_id = arr_ccid(i)
2981: AND ledger_id = arr_ledgerid(i);
2982:

Line 3002: UPDATE xla_trial_balances_gt

2998: USING trunc(p_start_date),
2999: trunc(p_as_of_date);
3000:
3001: FORALL i IN 1..arr_ccid.COUNT
3002: UPDATE xla_trial_balances_gt
3003: SET NON_AP_AMOUNT = arr_non_ap_amount(i)
3004: WHERE code_combination_id = arr_ccid(i)
3005: AND ledger_id = arr_ledgerid(i);
3006:

Line 3024: UPDATE xla_trial_balances_gt

3020: trunc(NVL(p_start_date,to_date('01-01-1950','DD-MM-YYYY'))),
3021: trunc(NVL(p_as_of_date,to_date('31-12-9999','DD-MM-YYYY')));
3022:
3023: FORALL i IN 1..arr_ccid.COUNT
3024: UPDATE xla_trial_balances_gt
3025: SET MANUAL_SLA_AMOUNT = arr_manual_sla_amount(i)
3026: WHERE code_combination_id = arr_ccid(i)
3027: AND ledger_id = arr_ledgerid(i);
3028: