DBA Data[Home] [Help]

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 141: hz_cust_site_uses_all su,

137: uba.instr_assignment_id,
138: uba.ext_party_id,
139: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
140: FROM oe_order_headers_all ooh,
141: hz_cust_site_uses_all su,
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,

Line 183: hz_cust_site_uses_all su,

179: uba.instr_assignment_id,
180: uba.ext_party_id,
181: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
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,

Line 227: hz_cust_site_uses_all su,

223: uba.instr_assignment_id,
224: uba.ext_party_id,
225: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
226: FROM oe_order_headers_all ooh,
227: hz_cust_site_uses_all su,
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,

Line 270: hz_cust_site_uses_all su,

266: uba.instr_assignment_id,
267: uba.ext_party_id,
268: iby_fndcpt_tx_extensions_s.nextval -- the new transaction extension ID
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,

Line 316: hz_cust_site_uses_all su,

312: uba.instr_assignment_id,
313: uba.ext_party_id,
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'