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.JTF_TASKS_PUB dependencies on HZ_CUST_ACCOUNTS

Line 663: l_cust_account_number hz_cust_accounts.account_number%TYPE := p_cust_account_number;

659: l_scheduled_start_date DATE := p_scheduled_start_date;
660: l_scheduled_end_date DATE := p_scheduled_end_date;
661: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
662: l_assigned_by_id NUMBER := p_assigned_by_id;
663: l_cust_account_number hz_cust_accounts.account_number%TYPE := p_cust_account_number;
664: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE := p_cust_account_id;
665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;
667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;

Line 664: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE := p_cust_account_id;

660: l_scheduled_end_date DATE := p_scheduled_end_date;
661: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
662: l_assigned_by_id NUMBER := p_assigned_by_id;
663: l_cust_account_number hz_cust_accounts.account_number%TYPE := p_cust_account_number;
664: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE := p_cust_account_id;
665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;
667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;
668: l_location_id hz_locations.location_id%TYPE := p_location_id;

Line 2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
2931: l_assigned_by_id NUMBER := p_assigned_by_id;
2932: l_customer_id hz_parties.party_id%TYPE;
2933: l_customer_number hz_parties.party_number%TYPE;
2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
2935: l_cust_account_number hz_cust_accounts.account_number%TYPE;
2936: l_address_id hz_party_sites.party_site_id%TYPE;
2937: l_location_id hz_locations.location_id%TYPE;
2938: l_address_number hz_party_sites.party_site_number%TYPE;

Line 2935: l_cust_account_number hz_cust_accounts.account_number%TYPE;

2931: l_assigned_by_id NUMBER := p_assigned_by_id;
2932: l_customer_id hz_parties.party_id%TYPE;
2933: l_customer_number hz_parties.party_number%TYPE;
2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
2935: l_cust_account_number hz_cust_accounts.account_number%TYPE;
2936: l_address_id hz_party_sites.party_site_id%TYPE;
2937: l_location_id hz_locations.location_id%TYPE;
2938: l_address_number hz_party_sites.party_site_number%TYPE;
2939: l_planned_start_date DATE;

Line 5447: FROM hz_cust_accounts

5443: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE
5444: ) IS
5445: CURSOR c1 IS
5446: SELECT cust_account_id
5447: FROM hz_cust_accounts
5448: WHERE account_number = p_cust_account_number;
5449: BEGIN
5450: IF (p_cust_account_number IS NOT NULL) THEN
5451: OPEN c1;