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_SALES_CREDIT_PVT dependencies on HZ_PARTIES

Line 441: FROM HZ_PARTIES

437: WHERE Cust_Account_Id = l_acct_id;
438:
439: CURSOR C_Get_Party_Info (l_party_id NUMBER) IS
440: SELECT Party_Name
441: FROM HZ_PARTIES
442: WHERE Party_Id = l_party_id;
443:
444: CURSOR C_Get_Party_Site_Info (l_party_site NUMBER) IS
445: SELECT UPPER(B.city) City, UPPER(B.county) County, UPPER(B.state)State, UPPER(B.province) Province, B.postal_code, B.country

Line 454: AND Owner_Table_Name = 'HZ_PARTIES'

450: CURSOR C_Get_Cust_Cont_Info (l_party_id NUMBER) IS
451: SELECT Phone_Area_Code
452: FROM HZ_CONTACT_POINTS
453: WHERE Owner_Table_Id = l_party_id
454: AND Owner_Table_Name = 'HZ_PARTIES'
455: AND Contact_Point_Type = 'PHONE'
456: AND Status = 'A'
457: AND Primary_Flag = 'Y';
458: