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.XTR_JOURNAL_PROCESS_P dependencies on XTR_GAIN_LOSS_DNM

Line 830: from xtr_gain_loss_dnm dnm,

826: ,jea.code_combination_id ccid
827: ,jea.amount_type amount_type
828: ,jea.action_code action_code
829: ,jea.date_type date_type
830: from xtr_gain_loss_dnm dnm,
831: xtr_journal_entry_actions jea,
832: xtr_deals dea
833: where dnm.batch_id = in_batch_id
834: and jea.company_code = in_company

Line 874: from xtr_gain_loss_dnm dnm,

870: ,jea.code_combination_id ccid
871: ,jea.amount_type amount_type
872: ,jea.action_code action_code
873: ,jea.date_type date_type
874: from xtr_gain_loss_dnm dnm,
875: xtr_journal_entry_actions jea,
876: xtr_rollover_transactions ro
877: where dnm.batch_id = in_batch_id
878: and jea.company_code = in_company

Line 916: from xtr_gain_loss_dnm dnm,

912: ,jea.code_combination_id ccid
913: ,jea.amount_type amount_type
914: ,jea.action_code action_code
915: ,jea.date_type date_type
916: from xtr_gain_loss_dnm dnm,
917: xtr_journal_entry_actions jea,
918: xtr_intergroup_transfers ig
919: where dnm.batch_id = in_batch_id
920: and jea.company_code = in_company

Line 958: from xtr_gain_loss_dnm dnm,

954: ,jea.code_combination_id ccid
955: ,jea.amount_type amount_type
956: ,jea.action_code action_code
957: ,jea.date_type date_type
958: from xtr_gain_loss_dnm dnm,
959: xtr_journal_entry_actions jea,
960: xtr_revaluation_details rd,
961: xtr_bank_accounts ba,
962: xtr_bank_balances bb

Line 997: -- cursor will fetch all FX deals from XTR_GAIN_LOSS_DNM table with

993: ------------------------------------------------------------------------------------------
994: -- NOTE: Q6 will process FX Forward deals for Revaluations and
995: -- Effectiveness testing journal entries only. This cursor will include
996: -- the normal FX deals and hedge associated FX Forward deals. This
997: -- cursor will fetch all FX deals from XTR_GAIN_LOSS_DNM table with
998: -- Amount_type/Date_type/Action combination defined in JEA set up, and
999: -- process the reval_eff_flag equal to 'T' (Efffective testing results) first.
1000: -- If any of the flag 'T' is found, then the flag 'R' for the same deal
1001: -- number /amout type will not be journalized.

Line 1023: from XTR_GAIN_LOSS_DNM dnm,

1019: jea.amount_type amount_type,
1020: jea.action_code action_code,
1021: jea.date_type date_type,
1022: dnm.reval_eff_flag reval_eff_flag
1023: from XTR_GAIN_LOSS_DNM dnm,
1024: XTR_DEALS dea,
1025: XTR_JOURNAL_ENTRY_ACTIONS jea
1026: Where dnm.batch_id = in_batch_id
1027: And jea.company_code = in_company

Line 1069: from XTR_GAIN_LOSS_DNM dnm,

1065: hac.code_combination_id ccid,
1066: hac.amount_type amount_type,
1067: hac.action_code action_code,
1068: hac.date_type date_type
1069: from XTR_GAIN_LOSS_DNM dnm,
1070: XTR_HEDGE_JOURNAL_ACTIONS hac,
1071: XTR_HEDGE_ATTRIBUTES att,
1072: XTR_HEDGE_STRATEGIES str
1073: Where dnm.batch_id = in_batch_id