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_FNDCPT_PAYER_ASSGN_INSTR_V

Line 866: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,

862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
863: ) IS
864: SELECT instr_assignment_id,
865: fpc.payment_channel_code
866: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,
867: iby_fndcpt_pmt_chnnls_vl fpc
868: WHERE ibyinstr.instrument_id = p_bank_id
869: AND ibyinstr.payment_function = p_payment_function
870: AND ibyinstr.party_id = p_party_id

Line 889: from IBY_FNDCPT_payer_assgn_instr_v

885: p_currency_code okl_k_headers_full_v.currency_code%type
886: ) IS
887: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
888: '1' || to_char(instr_assignment_id))), 2)
889: from IBY_FNDCPT_payer_assgn_instr_v
890: where instrument_type = 'BANKACCOUNT'
891: and cust_account_id = p_cust_acct_id
892: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
893: and currency_code = p_currency_code

Line 895: '1' || to_char(order_of_preference))), 2) from IBY_FNDCPT_payer_assgn_instr_v

891: and cust_account_id = p_cust_acct_id
892: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
893: and currency_code = p_currency_code
894: and order_of_preference = (select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(order_of_preference),
895: '1' || to_char(order_of_preference))), 2) from IBY_FNDCPT_payer_assgn_instr_v
896: where instrument_type = 'BANKACCOUNT'
897: and cust_account_id = p_cust_acct_id
898: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
899: and currency_code = p_currency_code

Line 1626: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,

1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
1623: ) IS
1624: SELECT instr_assignment_id,
1625: fpc.payment_channel_code
1626: FROM iby_fndcpt_payer_assgn_instr_v ibyinstr,
1627: iby_fndcpt_pmt_chnnls_vl fpc
1628: WHERE ibyinstr.instrument_id = p_bank_id
1629: AND ibyinstr.payment_function = p_payment_function
1630: AND ibyinstr.party_id = p_party_id

Line 1650: from IBY_FNDCPT_payer_assgn_instr_v

1646: p_currency_code okl_k_headers_full_v.currency_code%type
1647: ) IS
1648: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
1649: '1' || to_char(instr_assignment_id))), 2)
1650: from IBY_FNDCPT_payer_assgn_instr_v
1651: where instrument_type = 'BANKACCOUNT'
1652: and cust_account_id = p_cust_acct_id
1653: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
1654: and currency_code = p_currency_code

Line 1656: '1' || to_char(order_of_preference))), 2) from IBY_FNDCPT_payer_assgn_instr_v

1652: and cust_account_id = p_cust_acct_id
1653: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
1654: and currency_code = p_currency_code
1655: and order_of_preference = (select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(order_of_preference),
1656: '1' || to_char(order_of_preference))), 2) from IBY_FNDCPT_payer_assgn_instr_v
1657: where instrument_type = 'BANKACCOUNT'
1658: and cust_account_id = p_cust_acct_id
1659: and p_site_use_id = nvl(acct_site_use_id,p_site_use_id)
1660: and currency_code = p_currency_code