APPS.ASN_MIG_SALES_TEAM_PVT dependencies on AS_ACCESSES_ALL_CUST_TEMP

Line 662: into AS_ACCESSES_ALL_CUST_TEMP CUST

658: IF (fnd_conc_global.request_data IS NULL) THEN
659:
660: --Create temp table for customer -- @@
661: INSERT /*+ APPEND PARALLEL(CUST) */
662: into AS_ACCESSES_ALL_CUST_TEMP CUST
663: (customer_id,
664: code_access_id,
665: salesforce_id,
666: sales_group_id,

Line 766: From AS_ACCESSES_ALL_CUST_TEMP;

762: ELSIF i=2 THEN --cust
763:
764: Select count(DISTINCT customer_id),min(customer_id),max(customer_id)
765: into l_dup_count_cust,l_dup_min_cust,l_max_id
766: From AS_ACCESSES_ALL_CUST_TEMP;
767:
768: l_max_num_rows := l_dup_count_cust;
769: l_start_id := l_dup_min_cust-1;
770: ls_program := 'ASN_MIG_DUP_ST_CUST_PRG';

Line 775: FROM AS_ACCESSES_ALL_CUST_TEMP

771:
772: Select distinct customer_id
773: BULK COLLECT INTO
774: l_id_list
775: FROM AS_ACCESSES_ALL_CUST_TEMP
776: ORDER BY customer_id;
777: ELSE -- lead
778: Select count(DISTINCT sales_lead_id),min(sales_lead_id),max(sales_lead_id)
779: into l_dup_count_lead,l_dup_min_lead,l_max_id

Line 1046: FROM AS_ACCESSES_ALL_cust_TEMP temp ,hz_parties hz

1042: AND party_type IN ('ORGANIZATION', 'PERSON');*/
1043:
1044: CURSOR c_parties_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
1045: SELECT distinct temp.customer_id
1046: FROM AS_ACCESSES_ALL_cust_TEMP temp ,hz_parties hz
1047: WHERE temp.customer_id BETWEEN p_start_id AND p_end_id
1048: AND hz.party_type IN ('ORGANIZATION', 'PERSON')
1049: AND temp.customer_id=hz.party_id ;
1050:

Line 1075: FROM AS_ACCESSES_ALL_CUST_TEMP -- AS_ACCESSES_ALL

1071: max(FREEZE_FLAG) freeze_flag,
1072: max(TEAM_LEADER_FLAG) team_leader_flag,
1073: max(OWNER_FLAG) owner_flag,
1074: max(CONTRIBUTOR_FLAG) contributor_flag
1075: FROM AS_ACCESSES_ALL_CUST_TEMP -- AS_ACCESSES_ALL
1076: WHERE customer_id = p_party_id
1077: GROUP BY customer_id,salesforce_id, sales_group_id, partner_customer_id,
1078: partner_cont_party_id;
1079: --Code added for ASN migration approach suggested by lester -- End