DBA Data[Home] [Help]

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 180: hz_cust_site_uses_all su,

176: uba.instr_assignment_id,
177: uba.ext_party_id,
178: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
179: FROM oe_order_headers_all ooh,
180: hz_cust_site_uses_all su,
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,

Line 222: hz_cust_site_uses_all su,

218: uba.instr_assignment_id,
219: uba.ext_party_id,
220: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
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,

Line 266: hz_cust_site_uses_all su,

262: uba.instr_assignment_id,
263: uba.ext_party_id,
264: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
265: FROM oe_order_headers_all ooh,
266: hz_cust_site_uses_all su,
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,

Line 309: hz_cust_site_uses_all su,

305: uba.instr_assignment_id,
306: uba.ext_party_id,
307: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
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,

Line 355: hz_cust_site_uses_all su,

351: uba.instr_assignment_id,
352: uba.ext_party_id,
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'