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 165: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly

161:
162: -- Cursors that query all transactions needed to be migrated
163: -- since all credit cards for closed orders would have already created bank account id
164: -- in ap_bank_accounts, so we can get the bank_account_id first, then get the instrument
165: -- assignment id from IBY_UPG_INSTRUMENTS. With the instrument assignemen id, we can directly
166: -- create and insert a new record in Oracle Payments table IBY_FNDCPT_TX_EXTENSIONS.
167:
168: -- Define a cursor payments_cur1 to select the payment data that only exist in oe_order_headers_all
169: -- but not in oe_payments for closed orders

Line 185: iby_upg_instruments uba

181: hz_cust_acct_sites_all cas,
182: ap_bank_accounts_all ba,
183: ap_bank_account_uses_all bau,
184: iby_trans_all_v ita,
185: iby_upg_instruments uba
186: WHERE ooh.open_flag = 'N'
187: AND ooh.payment_type_code = 'CREDIT_CARD'
188: AND ooh.ordered_date >= l_cutoff_date
189: AND NOT EXISTS ( SELECT 'Y'

Line 225: iby_upg_instruments uba,

221: FROM oe_order_headers_all ooh,
222: hz_cust_site_uses_all su,
223: hz_cust_acct_sites_all cas,
224: iby_trans_all_v ita,
225: iby_upg_instruments uba,
226: iby_security_segments seg,
227: iby_creditcard cc
228: WHERE ooh.open_flag = 'N'
229: AND ooh.payment_type_code = 'CREDIT_CARD'

Line 271: iby_upg_instruments uba,

267: hz_cust_acct_sites_all cas,
268: ap_bank_accounts_all ba,
269: ap_bank_account_uses_all bau,
270: iby_trans_all_v ita,
271: iby_upg_instruments uba,
272: oe_payments op
273: WHERE ooh.open_flag = 'N'
274: AND ooh.ordered_date >= l_cutoff_date
275: AND ooh.header_id = op.header_id

Line 312: iby_upg_instruments uba,

308: FROM oe_order_headers_all ooh,
309: hz_cust_site_uses_all su,
310: hz_cust_acct_sites_all cas,
311: iby_trans_all_v ita,
312: iby_upg_instruments uba,
313: oe_payments op,
314: iby_security_segments seg,
315: iby_creditcard cc
316: WHERE ooh.open_flag = 'N'

Line 357: iby_upg_instruments uba,

353: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
354: FROM oe_order_headers_all ooh,
355: hz_cust_site_uses_all su,
356: hz_cust_acct_sites_all cas,
357: iby_upg_instruments uba,
358: oe_payments op
359: WHERE ooh.open_flag = 'N'
360: AND ooh.ordered_date >= l_cutoff_date
361: AND ooh.header_id = op.header_id