DBA Data[Home] [Help]

APPS.ASO_PAYMENT_DATA_MIGRATION_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 168: aso_quote_headers_all hdr,

164: lpad(sec.cc_unmask_digits, nvl(range.card_number_length, length(pmt.payment_ref_number)), 'X') masked_cc_number
165:
166: FROM aso_payments pmt,
167: iby_external_payers_all payer,
168: aso_quote_headers_all hdr,
169: iby_security_segments sec,
170: iby_cc_issuer_ranges range
171:
172: WHERE pmt.quote_header_id = hdr.quote_header_id

Line 212: aso_quote_headers_all hdr

208: lpad(substr(pmt.payment_ref_number, greatest(-4,-length(pmt.payment_ref_number))), length(pmt.payment_ref_number), 'X' ) masked_cc_number
209:
210: FROM aso_payments pmt,
211: iby_external_payers_all payer,
212: aso_quote_headers_all hdr
213:
214: WHERE pmt.quote_header_id = hdr.quote_header_id
215: and pmt.payment_type_code = 'CREDIT_CARD'
216: and pmt.payment_ref_number is not null