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.PA_CUSTOMER_INFO dependencies on HZ_CUST_ACCT_RELATE

Line 153: FROM hz_cust_acct_relate

149: --Commented the cursors C5 and C6 for bug#5478047
150:
151: /* CURSOR C5 IS
152: SELECT related_cust_account_id
153: FROM hz_cust_acct_relate
154: WHERE cust_account_id = X_Customer_Id
155: AND bill_to_flag = 'Y'
156: AND status = 'A'
157: AND related_cust_account_id = X_Bill_To_Customer_Id;

Line 161: FROM hz_cust_acct_relate

157: AND related_cust_account_id = X_Bill_To_Customer_Id;
158:
159: CURSOR C6 IS
160: SELECT related_cust_account_id
161: FROM hz_cust_acct_relate
162: WHERE cust_account_id = X_Customer_Id
163: AND ship_to_flag = 'Y'
164: AND status = 'A'
165: AND related_cust_account_id = X_Ship_To_Customer_Id; */

Line 171: FROM hz_cust_acct_relate

167: --Added the new cursors C5 and C6 for bug#5478047
168:
169: CURSOR C5 IS
170: SELECT cust_account_id
171: FROM hz_cust_acct_relate
172: WHERE related_cust_account_id = X_Customer_Id
173: AND bill_to_flag = 'Y'
174: AND status = 'A'
175: AND cust_account_id = X_Bill_To_Customer_Id; --Bug#5872732

Line 179: FROM hz_cust_acct_relate

175: AND cust_account_id = X_Bill_To_Customer_Id; --Bug#5872732
176:
177: CURSOR C6 IS
178: SELECT cust_account_id
179: FROM hz_cust_acct_relate
180: WHERE related_cust_account_id = X_Customer_Id
181: AND ship_to_flag = 'Y'
182: AND status = 'A'
183: AND cust_account_id = X_Ship_To_Customer_Id; --Bug#5872732