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_ASSET_SUBSIDY_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1225: hz_cust_accounts cust,

1221: cursor l_cclass_csr (p_subsidy_id in number,
1222: p_asset_cle_id in number) is
1223: select 'Y'
1224: from okc_k_headers_b chrb,
1225: hz_cust_accounts cust,
1226: okc_k_lines_b cleb,
1227: okl_subsidy_criteria suc
1228: where chrb.id = cleb.chr_id
1229: And cleb.dnz_chr_id = chrb.id

Line 1355: hz_cust_accounts_all hca,

1351: cursor l_sic_csr (p_subsidy_id in number,
1352: p_asset_cle_id in number) is
1353: select 'Y'
1354: from hz_parties hp,
1355: hz_cust_accounts_all hca,
1356: okc_k_lines_b cleb,
1357: okc_k_headers_b chrb,
1358: okl_subsidy_criteria suc
1359: where hp.party_id = hca.party_id

Line 1837: hz_cust_accounts cust,

1833: cursor l_cclass_csr (p_subsidy_id in number,
1834: p_chr_id in number) is
1835: select 'Y'
1836: from okc_k_headers_all_b chrb,
1837: hz_cust_accounts cust,
1838: okl_subsidy_criteria suc
1839: where chrb.id = p_chr_id
1840: And chrb.cust_acct_id = cust.cust_account_id
1841: And suc.subsidy_id = p_subsidy_id

Line 1908: hz_cust_accounts_all hca,

1904: cursor l_sic_csr (p_subsidy_id in number,
1905: p_chr_id in number) is
1906: select 'Y'
1907: from hz_parties hp,
1908: hz_cust_accounts_all hca,
1909: okc_k_headers_b chrb,
1910: okl_subsidy_criteria suc
1911: where hp.party_id = hca.party_id
1912: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id

Line 2342: hz_cust_accounts cust,

2338: /* cursor l_cclass_csr (p_subsidy_id in number,
2339: p_chr_id in number) is
2340: select 'Y'
2341: from okc_k_headers_b chrb,
2342: hz_cust_accounts cust,
2343: okl_subsidy_criteria suc
2344: where chrb.id = p_chr_id
2345: And chrb.cust_acct_id = to_char(cust.cust_account_id)
2346: And suc.subsidy_id = p_subsidy_id

Line 2354: from hz_cust_accounts cust,

2350: --cursor to check cutomer credit class
2351: cursor l_cclass_csr (p_subsidy_id in number,
2352: p_cust_account_id in number) is
2353: select 'Y'
2354: from hz_cust_accounts cust,
2355: okl_subsidy_criteria suc
2356: where cust.cust_account_id = p_cust_account_id
2357: And suc.subsidy_id = p_subsidy_id
2358: And SUC.CREDIT_CLASSIFICATION_CODE = cust.CREDIT_CLASSIFICATION_CODE

Line 2463: hz_cust_accounts_all hca,

2459: cursor l_sic_csr (p_subsidy_id in number,
2460: p_cust_account_id in number) is
2461: select 'Y'
2462: from hz_parties hp,
2463: hz_cust_accounts_all hca,
2464: okl_subsidy_criteria suc
2465: where hp.party_id = hca.party_id
2466: And hca.CUST_ACCOUNT_ID = p_cust_account_id
2467: And SUC.subsidy_id = p_subsidy_id