[Home] [Help]
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'
230: AND ooh.ordered_date >= l_cutoff_date
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'
317: AND ooh.ordered_date >= l_cutoff_date
318: AND ooh.header_id = op.header_id