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.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_UPG_INSTRUMENTS

Line 126: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly

122:
123: -- Cursors that query all transactions needed to be migrated
124: -- since all credit cards for closed orders would have already created bank account id
125: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument
126: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
127: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
128:
129: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
130: -- but not in oe_payments for closed orders

Line 146: iby_upg_instruments uba

142: hz_cust_acct_sites_all cas,
143: ap_bank_accounts_all ba,
144: ap_bank_account_uses_all bau,
145: iby_trans_all_v ita,
146: iby_upg_instruments uba
147: WHERE ooh.open_flag = 'N'
148: AND ooh.payment_type_code = 'CREDIT_CARD'
149: AND ooh.ordered_date >= l_cutoff_date
150: AND NOT EXISTS ( SELECT 'Y'

Line 186: iby_upg_instruments uba,

182: FROM oe_order_headers_all ooh,
183: hz_cust_site_uses_all su,
184: hz_cust_acct_sites_all cas,
185: iby_trans_all_v ita,
186: iby_upg_instruments uba,
187: iby_security_segments seg,
188: iby_creditcard cc
189: WHERE ooh.open_flag = 'N'
190: AND ooh.payment_type_code = 'CREDIT_CARD'

Line 232: iby_upg_instruments uba,

228: hz_cust_acct_sites_all cas,
229: ap_bank_accounts_all ba,
230: ap_bank_account_uses_all bau,
231: iby_trans_all_v ita,
232: iby_upg_instruments uba,
233: oe_payments op
234: WHERE ooh.open_flag = 'N'
235: AND ooh.ordered_date >= l_cutoff_date
236: AND ooh.header_id = op.header_id

Line 273: iby_upg_instruments uba,

269: FROM oe_order_headers_all ooh,
270: hz_cust_site_uses_all su,
271: hz_cust_acct_sites_all cas,
272: iby_trans_all_v ita,
273: iby_upg_instruments uba,
274: oe_payments op,
275: iby_security_segments seg,
276: iby_creditcard cc
277: WHERE ooh.open_flag = 'N'

Line 318: iby_upg_instruments uba,

314: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
315: FROM oe_order_headers_all ooh,
316: hz_cust_site_uses_all su,
317: hz_cust_acct_sites_all cas,
318: iby_upg_instruments uba,
319: oe_payments op
320: WHERE ooh.open_flag = 'N'
321: AND ooh.ordered_date >= l_cutoff_date
322: AND ooh.header_id = op.header_id