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.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_CASE_OBJECTS

Line 14097: select count(*) into l_contracts_count(temp) from iex_case_objects where cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id = r_org.org_id);

14093: temp := 1;
14094: for r_contract in c_contract_summary(r_org.org_id) loop
14095: select count(*) into l_cases_count(temp) from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id;
14096: select count(*) into l_del_cases_count(temp) from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id and status_code='DELINQUENT';
14097: select count(*) into l_contracts_count(temp) from iex_case_objects where cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id = r_org.org_id);
14098: select count(*) into l_del_contracts_count(temp) from iex_case_objects where delinquency_status='DELINQUENT' and cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id );
14099: l_party_id(temp) := r_contract.party_id;
14100: l_org_id(temp) := r_org.org_id;
14101: temp := temp+1;

Line 14098: select count(*) into l_del_contracts_count(temp) from iex_case_objects where delinquency_status='DELINQUENT' and cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id );

14094: for r_contract in c_contract_summary(r_org.org_id) loop
14095: select count(*) into l_cases_count(temp) from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id;
14096: select count(*) into l_del_cases_count(temp) from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id and status_code='DELINQUENT';
14097: select count(*) into l_contracts_count(temp) from iex_case_objects where cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id = r_org.org_id);
14098: select count(*) into l_del_contracts_count(temp) from iex_case_objects where delinquency_status='DELINQUENT' and cas_id in (select cas_id from iex_cases_all_b where party_id=r_contract.party_id and org_id=r_org.org_id );
14099: l_party_id(temp) := r_contract.party_id;
14100: l_org_id(temp) := r_org.org_id;
14101: temp := temp+1;
14102: