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.ASN_MIG_SALES_TEAM_PVT dependencies on AS_ACCESSES_ALL_OPP_TEMP

Line 191: FROM AS_ACCESSES_ALL_OPP_TEMP

187: WHERE lead_id BETWEEN p_start_id AND p_end_id; */
188:
189: CURSOR c_opps_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
190: SELECT DISTINCT lead_id
191: FROM AS_ACCESSES_ALL_OPP_TEMP
192: WHERE lead_id BETWEEN p_start_id AND p_end_id;
193:
194: /* CURSOR c_uniq_steam(p_lead_id NUMBER) IS
195: SELECT max(decode(SALESFORCE_ROLE_CODE, NULL, 'N', 'Y') || ACCESS_ID) code_access_id,

Line 217: FROM AS_ACCESSES_ALL_OPP_TEMP -- AS_ACCESSES_ALL

213: max(FREEZE_FLAG) freeze_flag,
214: max(TEAM_LEADER_FLAG) team_leader_flag,
215: max(OWNER_FLAG) owner_flag,
216: max(CONTRIBUTOR_FLAG) contributor_flag
217: FROM AS_ACCESSES_ALL_OPP_TEMP -- AS_ACCESSES_ALL
218: WHERE lead_id = p_lead_id
219: GROUP BY lead_id,salesforce_id, sales_group_id, partner_customer_id,
220: partner_cont_party_id;
221:

Line 710: INSERT /+ APPEND PARALLEL(CUST) / into AS_ACCESSES_ALL_OPP_TEMP CUST

706: GROUP BY sales_lead_id,salesforce_id, sales_group_id
707: HAVING count(access_id) > 1;
708: COMMIT;
709:
710: INSERT /*+ APPEND PARALLEL(CUST) */ into AS_ACCESSES_ALL_OPP_TEMP CUST
711: (lead_id,
712: code_access_id,
713: salesforce_id,
714: sales_group_id,

Line 750: From AS_ACCESSES_ALL_OPP_TEMP;

746: l_id_list.delete;
747: IF i=1 THEN --Opp
748: Select count(DISTINCT lead_id),min(lead_id),max(lead_id)
749: into l_dup_count_opp,l_dup_min_opp,l_max_id
750: From AS_ACCESSES_ALL_OPP_TEMP;
751:
752: l_max_num_rows := l_dup_count_opp;
753: l_start_id := l_dup_min_opp-1;
754: ls_program := 'ASN_MIG_DUP_ST_OPP_PRG';

Line 759: FROM AS_ACCESSES_ALL_OPP_TEMP