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 1208: hz_cust_accounts cust,

1204: cursor l_cclass_csr (p_subsidy_id in number,
1205: p_asset_cle_id in number) is
1206: select 'Y'
1207: from okc_k_headers_b chrb,
1208: hz_cust_accounts cust,
1209: okc_k_lines_b cleb,
1210: okl_subsidy_criteria suc
1211: where chrb.id = cleb.chr_id
1212: And cleb.dnz_chr_id = chrb.id

Line 1338: hz_cust_accounts_all hca,

1334: cursor l_sic_csr (p_subsidy_id in number,
1335: p_asset_cle_id in number) is
1336: select 'Y'
1337: from hz_parties hp,
1338: hz_cust_accounts_all hca,
1339: okc_k_lines_b cleb,
1340: okc_k_headers_b chrb,
1341: okl_subsidy_criteria suc
1342: where hp.party_id = hca.party_id

Line 1816: hz_cust_accounts cust,

1812: cursor l_cclass_csr (p_subsidy_id in number,
1813: p_chr_id in number) is
1814: select 'Y'
1815: from okc_k_headers_all_b chrb,
1816: hz_cust_accounts cust,
1817: okl_subsidy_criteria suc
1818: where chrb.id = p_chr_id
1819: And chrb.cust_acct_id = cust.cust_account_id
1820: And suc.subsidy_id = p_subsidy_id

Line 1887: hz_cust_accounts_all hca,

1883: cursor l_sic_csr (p_subsidy_id in number,
1884: p_chr_id in number) is
1885: select 'Y'
1886: from hz_parties hp,
1887: hz_cust_accounts_all hca,
1888: okc_k_headers_b chrb,
1889: okl_subsidy_criteria suc
1890: where hp.party_id = hca.party_id
1891: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id

Line 2321: hz_cust_accounts cust,

2317: /* cursor l_cclass_csr (p_subsidy_id in number,
2318: p_chr_id in number) is
2319: select 'Y'
2320: from okc_k_headers_b chrb,
2321: hz_cust_accounts cust,
2322: okl_subsidy_criteria suc
2323: where chrb.id = p_chr_id
2324: And chrb.cust_acct_id = to_char(cust.cust_account_id)
2325: And suc.subsidy_id = p_subsidy_id

Line 2333: from hz_cust_accounts cust,

2329: --cursor to check cutomer credit class
2330: cursor l_cclass_csr (p_subsidy_id in number,
2331: p_cust_account_id in number) is
2332: select 'Y'
2333: from hz_cust_accounts cust,
2334: okl_subsidy_criteria suc
2335: where cust.cust_account_id = p_cust_account_id
2336: And suc.subsidy_id = p_subsidy_id
2337: And SUC.CREDIT_CLASSIFICATION_CODE = cust.CREDIT_CLASSIFICATION_CODE

Line 2442: hz_cust_accounts_all hca,

2438: cursor l_sic_csr (p_subsidy_id in number,
2439: p_cust_account_id in number) is
2440: select 'Y'
2441: from hz_parties hp,
2442: hz_cust_accounts_all hca,
2443: okl_subsidy_criteria suc
2444: where hp.party_id = hca.party_id
2445: And hca.CUST_ACCOUNT_ID = p_cust_account_id
2446: And SUC.subsidy_id = p_subsidy_id