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.ASO_APR_WF_PVT dependencies on HZ_PARTIES

Line 4230: hz_parties hp

4226: c_quote_header_id NUMBER
4227: ) IS
4228: SELECT hp.party_name
4229: FROM aso_quote_headers_all qha,
4230: hz_parties hp
4231: WHERE qha.cust_party_id = hp.party_id
4232: AND qha.quote_header_id = c_quote_header_id;
4233:
4234: -- bug 3934660 (put outer join)

Line 4260: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4256: -- bug 3934660
4257:
4258: CURSOR get_party_type (c_approval_id NUMBER) IS
4259: SELECT P.PARTY_TYPE
4260: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4261: WHERE p.party_id = qh.party_id
4262: AND qh.quote_header_id = aoa.object_id
4263: AND aoa.object_approval_id = c_approval_id;
4264:

Line 4271: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4267: CURSOR get_contact_name (
4268: c_approval_id NUMBER
4269: ) IS
4270: SELECT party_name
4271: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4272: WHERE p.party_id = r.object_id
4273: AND r.party_id = qh.party_id
4274: AND r.subject_id = qh.cust_party_id
4275: AND r.object_type = 'PERSON'

Line 5065: hz_parties hp,

5061: c_quote_header_id NUMBER
5062: ) IS
5063: SELECT hca.cust_account_id, hp.party_type
5064: FROM aso_quote_headers_all qha,
5065: hz_parties hp,
5066: hz_cust_accounts hca
5067: WHERE qha.quote_header_id = c_quote_header_id
5068: AND nvl(qha.cust_account_id,0 ) = hca.cust_account_id (+)
5069: AND qha.cust_party_id = hp.party_id;