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.CSP_SHIP_TO_ADDRESS_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;

2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;

Line 2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;

2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;

Line 3019: select resource_type_code, resource_id from jtf_task_assignments where task_assignment_id = p_task_assignment_id and assignee_role = 'ASSIGNEE';

3015: and jrre.category = 'PARTY';
3016:
3017:
3018: CURSOR l_resource_id_csr IS
3019: select resource_type_code, resource_id from jtf_task_assignments where task_assignment_id = p_task_assignment_id and assignee_role = 'ASSIGNEE';
3020:
3021: CURSOR l_customer_id_csr IS
3022: select rs_cust_relation_id,
3023: customer_id