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

Line 843: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
840: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
841: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
842: SELECT instrument_payment_use_id, fpc.payment_channel_code
843: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc
844: WHERE ibyinstr.instrument_id = p_bank_id
845: AND ibyinstr.payment_flow = p_payment_flow
846: AND pay.payment_function = p_payment_function
847: AND ibyinstr.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID

Line 975: iby_external_payers_all pay

971: PIU.ORDER_OF_PREFERENCE,
972: PIU.PAYMENT_FLOW
973: FROM IBY_PMT_INSTR_USES_ALL PIU,
974: IBY_CREDITCARD ccard,
975: iby_external_payers_all pay
976: WHERE ccard.INSTRID = PIU.instrument_id
977: AND PIU.INSTRUMENT_TYPE = p_instrument_type
978: AND sysdate <= NVL(ccard.inactive_date,sysdate)
979: AND PIU.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID

Line 992: iby_external_payers_all pay

988: PIU.ORDER_OF_PREFERENCE,
989: PIU.PAYMENT_FLOW
990: FROM IBY_PMT_INSTR_USES_ALL PIU,
991: iby_ext_bank_accounts eb,
992: iby_external_payers_all pay
993: WHERE PIU.instrument_id = eb.ext_bank_account_id
994: AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'
995: AND PIU.INSTRUMENT_TYPE = p_instrument_type
996: AND PIU.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID

Line 1604: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

1600: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1601: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
1602: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
1603: SELECT instrument_payment_use_id,fpc.payment_channel_code
1604: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc
1605: WHERE ibyinstr.instrument_id = p_bank_id
1606: AND ibyinstr.payment_flow = p_payment_flow
1607: AND pay.payment_function = p_payment_function
1608: AND ibyinstr.EXT_PMT_PARTY_ID = pay.EXT_PAYER_ID