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.AS_OPP_MERGE_PKG dependencies on AS_SALES_CREDITS_DENORM

Line 162: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_customer_id';

158: program_id = hz_utility_pub.program_id,
159: program_update_date = sysdate
160: where partner_customer_id = p_from_fk_id;
161:
162: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_customer_id';
163:
164: UPDATE AS_SALES_CREDITS_DENORM
165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,

Line 164: UPDATE AS_SALES_CREDITS_DENORM

160: where partner_customer_id = p_from_fk_id;
161:
162: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_customer_id';
163:
164: UPDATE AS_SALES_CREDITS_DENORM
165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,

Line 175: l_col_name := 'AS_SALES_CREDITS_DENORM.customer_id';

171: program_id = hz_utility_pub.program_id,
172: program_update_date = sysdate
173: where partner_customer_id = p_from_fk_id;
174:
175: l_col_name := 'AS_SALES_CREDITS_DENORM.customer_id';
176:
177: UPDATE AS_SALES_CREDITS_DENORM
178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,

Line 177: UPDATE AS_SALES_CREDITS_DENORM

173: where partner_customer_id = p_from_fk_id;
174:
175: l_col_name := 'AS_SALES_CREDITS_DENORM.customer_id';
176:
177: UPDATE AS_SALES_CREDITS_DENORM
178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,

Line 189: -- add AS_SALES_CREDITS_DENORM.close_competitor_id

185: program_update_date = sysdate
186: where customer_id = p_from_fk_id;
187:
188: -- add AS_LEADS_LOG.customer_id and AS_LEADS_LOG.close_competitor_id
189: -- add AS_SALES_CREDITS_DENORM.close_competitor_id
190:
191: l_col_name := 'AS_LEADS_LOG.customer_id';
192:
193: UPDATE AS_LEADS_LOG

Line 217: l_col_name := 'AS_SALES_CREDITS_DENORM.close_competitor_id';

213: --program_id = hz_utility_pub.program_id,
214: --program_update_date = sysdate
215: where close_competitor_id = p_from_fk_id;
216:
217: l_col_name := 'AS_SALES_CREDITS_DENORM.close_competitor_id';
218:
219: UPDATE AS_SALES_CREDITS_DENORM
220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,

Line 219: UPDATE AS_SALES_CREDITS_DENORM

215: where close_competitor_id = p_from_fk_id;
216:
217: l_col_name := 'AS_SALES_CREDITS_DENORM.close_competitor_id';
218:
219: UPDATE AS_SALES_CREDITS_DENORM
220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,

Line 287: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_address_id';

283: program_id = hz_utility_pub.program_id,
284: program_update_date = sysdate
285: where partner_address_id = p_from_fk_id;
286:
287: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_address_id';
288:
289: UPDATE AS_SALES_CREDITS_DENORM
290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,

Line 289: UPDATE AS_SALES_CREDITS_DENORM

285: where partner_address_id = p_from_fk_id;
286:
287: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_address_id';
288:
289: UPDATE AS_SALES_CREDITS_DENORM
290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,

Line 300: l_col_name := 'AS_SALES_CREDITS_DENORM.address_id';

296: program_id = hz_utility_pub.program_id,
297: program_update_date = sysdate
298: where partner_address_id = p_from_fk_id;
299:
300: l_col_name := 'AS_SALES_CREDITS_DENORM.address_id';
301:
302: UPDATE AS_SALES_CREDITS_DENORM
303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,

Line 302: UPDATE AS_SALES_CREDITS_DENORM

298: where partner_address_id = p_from_fk_id;
299:
300: l_col_name := 'AS_SALES_CREDITS_DENORM.address_id';
301:
302: UPDATE AS_SALES_CREDITS_DENORM
303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,