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 829: from xtr_gain_loss_dnm dnm,

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

Line 873: from xtr_gain_loss_dnm dnm,

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

Line 915: from xtr_gain_loss_dnm dnm,

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

Line 957: from xtr_gain_loss_dnm dnm,

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

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

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

Line 1022: from XTR_GAIN_LOSS_DNM dnm,

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

Line 1068: from XTR_GAIN_LOSS_DNM dnm,

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