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.ASO_PAYMENT_DATA_MIGRATION_PVT dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 138: Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that

134:
135: /*
136: Cursor that queries all transactions needed to be migrated
137:
138: Note: 1. This table is out-joined with the table IBY_EXTERNAL_PAYERS_ALL so that
139: the party contexts that are not in the external payer table can be identified.
140:
141: 2. The credit card number needs to be numeric.
142: */

Line 155: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval, PAYER.EXT_PAYER_ID),

151: to_char(hdr.quote_header_id) trxn_ref_number1,
152: nvl(hdr.invoice_to_cust_party_id, hdr.cust_party_id), --party_id
153: IBY_FNDCPT_TX_EXTENSIONS_S.nextval, --trxn_extension_id
154: IBY_INSTR_S.nextval,
155: DECODE(PAYER.EXT_PAYER_ID, null, IBY_EXTERNAL_PAYERS_ALL_S.nextval, PAYER.EXT_PAYER_ID),
156: DECODE(PAYER.EXT_PAYER_ID, null,'Y', 'N'), -- this flag determines whether we should create new external payer
157: IBY_PMT_INSTR_USES_ALL_S.nextval, -- the new instrument use id
158: sec.cc_number_hash1,
159: sec.cc_number_hash2,

Line 167: iby_external_payers_all payer,

163: sec.cc_unmask_digits,
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:

Line 199: decode(payer.ext_payer_id, null, iby_external_payers_all_s.nextval, payer.ext_payer_id),

195: to_char(hdr.quote_header_id) trxn_ref_number1,
196: nvl(hdr.invoice_to_cust_party_id, hdr.cust_party_id), --party_id
197: iby_fndcpt_tx_extensions_s.nextval, --trxn_extension_id
198: iby_instr_s.nextval,
199: decode(payer.ext_payer_id, null, iby_external_payers_all_s.nextval, payer.ext_payer_id),
200: decode(payer.ext_payer_id, null,'Y', 'N'), -- this flag determines whether we should create new external payer
201: iby_pmt_instr_uses_all_s.nextval, -- the new instrument use id
202: iby_fndcpt_setup_pub.get_hash(pmt.payment_ref_number, fnd_api.g_false) cc_number_hash1,
203: iby_fndcpt_setup_pub.get_hash(pmt.payment_ref_number, fnd_api.g_true) cc_number_hash2,

Line 211: iby_external_payers_all payer,

207: substr(pmt.payment_ref_number,greatest(-4,-length(pmt.payment_ref_number))) cc_unmask_digits,
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'

Line 484: FROM IBY_EXTERNAL_PAYERS_ALL

480: l_user_id,
481: 1,
482: 'FUNDS_CAPTURE'
483:
484: FROM IBY_EXTERNAL_PAYERS_ALL
485:
486: -- Note: For products that do not use all the party context columns, it is mandatory to
487: -- add NOT NULL clause for those columns.
488:

Line 763: FROM IBY_EXTERNAL_PAYERS_ALL

759: l_user_id,
760: 1,
761: 'FUNDS_CAPTURE'
762:
763: FROM IBY_EXTERNAL_PAYERS_ALL
764:
765: -- Note: For products that do not use all the party context columns, it is mandatory to
766: -- add NOT NULL clause for those columns.
767: