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_PARTS_REQUIREMENT dependencies on JTF_TASK_ASSIGNMENTS

Line 205: jtf_task_assignments jta

201: hz_cust_site_uses csu,
202: po_location_associations pla,
203: hz_party_sites ps,
204: hz_locations hzl,
205: jtf_task_assignments jta
206: where rcr.customer_id = cas.cust_account_id
207: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
208: and csu.site_use_code = 'SHIP_TO'
209: and csu.site_use_id = pla.site_use_id

Line 820: jtf_task_assignments jta,

816: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
817: SELECT cla.organization_id,
818: cla.subinventory_code
819: FROM csp_requirement_headers crh,
820: jtf_task_assignments jta,
821: csp_INV_LOC_ASSIGNMENTS cla
822: WHERE cla.default_code = 'IN'
823: AND cla.resource_type = decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
824: AND cla.resource_id = decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id)

Line 2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

2653: AND default_code = 'IN';
2654:
2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN

Line 2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

2654:
2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN
2662: OPEN get_resource_location;

Line 2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN
2662: OPEN get_resource_location;
2663: FETCH get_resource_location INTO l_ship_to_location_id;

Line 2693: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records

2689: ( x_return_status OUT NOCOPY varchar2) IS
2690:
2691: CURSOR c_task_assignment( b_task_assignment_id NUMBER ) IS
2692: SELECT resource_id
2693: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records
2694: WHERE task_assignment_id = b_task_assignment_id;
2695:
2696: l_task_assignment_id NUMBER;
2697: BEGIN

Line 2699: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

2695:
2696: l_task_assignment_id NUMBER;
2697: BEGIN
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;
2699: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2700:
2701: OPEN c_task_assignment(l_task_assignment_id);
2702: FETCH c_task_assignment INTO G_old_resource_id;
2703: CLOSE c_task_assignment;