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 OKL_K_HEADERS_FULL_V

Line 792: FROM OKL_K_HEADERS_FULL_V khr

788: , khr.contract_number
789: , khr.application_id app_id
790: , khr.BILL_TO_SITE_USE_ID
791: , khr.CURRENCY_CODE
792: FROM OKL_K_HEADERS_FULL_V khr
793: , OKC_K_PARTY_ROLES_B CPR
794: WHERE khr.ID = cpr.chr_id
795: AND cpr.rle_code = 'LESSEE'
796: AND khr.ID = cp_khr_id;

Line 838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

834: /* CURSOR instrument_payment_use_id_csr(
835: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
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

Line 840: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,

836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
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

Line 859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

855: CURSOR instrument_payment_use_id_csr(
856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
863: ) IS

Line 861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE

857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
863: ) IS
864: SELECT instr_assignment_id,
865: fpc.payment_channel_code

Line 883: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

879: -- Bug# 11669781: added payment_channel_code
880: l_payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
881:
882: CURSOR cust_instr_payment_use_id_csr (
883: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
884: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
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),

Line 885: p_currency_code okl_k_headers_full_v.currency_code%type

881:
882: CURSOR cust_instr_payment_use_id_csr (
883: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
884: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
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

Line 1553: FROM OKL_K_HEADERS_FULL_V khr

1549: , khr.contract_number
1550: , khr.application_id app_id
1551: , khr.BILL_TO_SITE_USE_ID
1552: , khr.CURRENCY_CODE
1553: FROM OKL_K_HEADERS_FULL_V khr
1554: , OKC_K_PARTY_ROLES_B CPR
1555: WHERE khr.ID = cpr.chr_id
1556: AND cpr.rle_code = 'LESSEE'
1557: AND khr.ID = cp_khr_id;

Line 1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

1595: --instrument_payment_use_id to be passed to IBY Bug 7162253
1596: /* CURSOR instrument_payment_use_id_csr(
1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
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

Line 1601: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,

1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
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

Line 1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

1615: -- bug 11886651
1616: CURSOR instrument_payment_use_id_csr(
1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
1623: ) IS

Line 1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE

1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
1623: ) IS
1624: SELECT instr_assignment_id,
1625: fpc.payment_channel_code

Line 1644: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,

1640: -- sosharma 10167846 added payment_channel_code
1641: payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
1642:
1643: CURSOR cust_instr_payment_use_id_csr (
1644: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1645: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
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),

Line 1646: p_currency_code okl_k_headers_full_v.currency_code%type

1642:
1643: CURSOR cust_instr_payment_use_id_csr (
1644: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1645: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
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