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.OE_PREPAYMENT_UTIL dependencies on IBY_FNDCPT_SETUP_PUB

Line 363: AND ite.cc_number_hash1 = DECODE(p_credit_card_number, null, ite.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))

359: AND oh.payment_type_code = 'CREDIT_CARD'
360: -- AND oh.credit_card_number = NVL(p_credit_card_number, oh.credit_card_number)
361: -- AND nvl(oh.credit_card_code, 'XXX') = NVL(p_credit_card_type, nvl(oh.credit_card_code, 'XXX'))
362: AND oh.header_id = ite.order_id
363: AND ite.cc_number_hash1 = DECODE(p_credit_card_number, null, ite.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
364: AND ite.cc_number_hash2 = DECODE(p_credit_card_number, null, ite.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
365: AND nvl(ite.card_issuer_code, 'XXX') = nvl(p_credit_card_type, nvl(ite.card_issuer_code, 'XXX'))
366: AND oh.invoice_to_org_id = NVL(p_bill_to_org_id, oh.invoice_to_org_id)
367: AND oh.booked_date >= NVL(l_booked_date_since, oh.booked_date)

Line 364: AND ite.cc_number_hash2 = DECODE(p_credit_card_number, null, ite.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))

360: -- AND oh.credit_card_number = NVL(p_credit_card_number, oh.credit_card_number)
361: -- AND nvl(oh.credit_card_code, 'XXX') = NVL(p_credit_card_type, nvl(oh.credit_card_code, 'XXX'))
362: AND oh.header_id = ite.order_id
363: AND ite.cc_number_hash1 = DECODE(p_credit_card_number, null, ite.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
364: AND ite.cc_number_hash2 = DECODE(p_credit_card_number, null, ite.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
365: AND nvl(ite.card_issuer_code, 'XXX') = nvl(p_credit_card_type, nvl(ite.card_issuer_code, 'XXX'))
366: AND oh.invoice_to_org_id = NVL(p_bill_to_org_id, oh.invoice_to_org_id)
367: AND oh.booked_date >= NVL(l_booked_date_since, oh.booked_date)
368: AND oh.order_category_code <> 'RETURN'

Line 410: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))

406: AND oh.order_number BETWEEN NVL(p_order_number_from, oh.order_number)
407: AND NVL(p_order_number_to, oh.order_number)
408: AND oh.header_id = op.header_id
409: AND to_char(op.header_id) = x.order_id --Bug#9696998
410: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
411: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
412: AND nvl(c.card_issuer_code, 'XXX') = nvl(p_credit_card_type, nvl(c.card_issuer_code, 'XXX'))
413: AND op.trxn_extension_id = x.trxn_extension_id
414: AND x.instr_assignment_id = u.instrument_payment_use_id

Line 411: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))

407: AND NVL(p_order_number_to, oh.order_number)
408: AND oh.header_id = op.header_id
409: AND to_char(op.header_id) = x.order_id --Bug#9696998
410: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
411: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
412: AND nvl(c.card_issuer_code, 'XXX') = nvl(p_credit_card_type, nvl(c.card_issuer_code, 'XXX'))
413: AND op.trxn_extension_id = x.trxn_extension_id
414: AND x.instr_assignment_id = u.instrument_payment_use_id
415: AND u.instrument_id = c.instrid

Line 502: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))

498: AND ol.header_id = op.header_id
499: AND op.payment_type_code = 'CREDIT_CARD'
500: AND to_char(ol.header_id) = x.order_id --Bug#9696998
501: AND to_char(ol.line_id) = x.trxn_ref_number1 --Bug#9696998 --order line_id
502: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
503: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
504: AND nvl(c.card_issuer_code, 'XXX') = nvl(p_credit_card_type,
505: nvl(c.card_issuer_code, 'XXX'))
506: AND oh.invoice_to_org_id = NVL(p_bill_to_org_id, oh.invoice_to_org_id)

Line 503: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))

499: AND op.payment_type_code = 'CREDIT_CARD'
500: AND to_char(ol.header_id) = x.order_id --Bug#9696998
501: AND to_char(ol.line_id) = x.trxn_ref_number1 --Bug#9696998 --order line_id
502: AND c.cc_number_hash1 = DECODE(p_credit_card_number, null, c.cc_number_hash1, iby_fndcpt_setup_pub.get_hash(p_Credit_Card_Number, 'F'))
503: AND c.cc_number_hash2 = DECODE(p_credit_card_number, null, c.cc_number_hash2, iby_fndcpt_setup_pub.get_hash(p_credit_card_number, 'T'))
504: AND nvl(c.card_issuer_code, 'XXX') = nvl(p_credit_card_type,
505: nvl(c.card_issuer_code, 'XXX'))
506: AND oh.invoice_to_org_id = NVL(p_bill_to_org_id, oh.invoice_to_org_id)
507: AND oh.booked_date >= NVL(l_booked_date_since, oh.booked_date)