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 HZ_PARTIES

Line 613: CURSOR c1 IS SELECT hz_parties_s.nextval FROM dual;

609: l_start_id NUMBER;
610: l_end_id NUMBER;
611: l_batch_size CONSTANT NUMBER := 10000;
612:
613: CURSOR c1 IS SELECT hz_parties_s.nextval FROM dual;
614:
615: --Code added for ASN migration approach suggested by lester -- Start
616: ls_create_temp varchar2(1000);
617: l_dup_count_cust NUMBER;

Line 1040: FROM hz_parties

1036: l_user_id NUMBER;
1037:
1038: /* CURSOR c_parties_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
1039: SELECT party_id
1040: FROM hz_parties
1041: WHERE party_id BETWEEN p_start_id AND p_end_id
1042: AND party_type IN ('ORGANIZATION', 'PERSON');*/
1043:
1044: CURSOR c_parties_in_range(p_start_id NUMBER, p_end_id NUMBER) IS

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: