[Home] [Help]
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: */
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,
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,