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 208: jtf_task_assignments jta

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

Line 835: jtf_task_assignments jta,

831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,
833: cla.subinventory_code
834: FROM csp_requirement_headers crh,
835: jtf_task_assignments jta,
836: csp_INV_LOC_ASSIGNMENTS cla
837: WHERE cla.default_code = 'IN'
838: AND cla.resource_type = decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
839: AND cla.resource_id = decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id)

Line 2767: jtf_task_assignments jta

2763: FROM csp_rs_ship_to_addresses_all_v csp,
2764: hz_cust_acct_sites_All hz,
2765: cs_incidents_all_b cs,
2766: jtf_tasks_b jtb,
2767: jtf_task_assignments jta
2768: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id
2769: AND csp.resource_id = jta.resource_id
2770: AND csp.resource_type = jta.resource_type_code
2771: AND primary_flag = 'Y'

Line 2841: from jtf_task_assignments

2837: and line.requirement_line_id = dtl.requirement_line_id;
2838:
2839: cursor get_task_asg_sts_id is
2840: select assignment_status_id
2841: from jtf_task_assignments
2842: where task_assignment_id = l_task_assignment_id;
2843:
2844: cursor get_order_header_id is
2845: SELECT oel.header_id

Line 2846: FROM jtf_task_assignments jta,

2842: where task_assignment_id = l_task_assignment_id;
2843:
2844: cursor get_order_header_id is
2845: SELECT oel.header_id
2846: FROM jtf_task_assignments jta,
2847: csp_requirement_headers ch,
2848: csp_requirement_lines cl,
2849: csp_req_line_details cld,
2850: oe_order_lines_all oel

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

2916: || ', l_subinventory_code = ' || l_subinventory_code);
2917: end if;
2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

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

2917: end if;
2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;

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

2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:

Line 2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;

2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2929: 'l_task_assignment_id = ' || l_task_assignment_id

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

4103: ( x_return_status OUT NOCOPY varchar2) IS
4104:
4105: CURSOR c_task_assignment( b_task_assignment_id NUMBER ) IS
4106: SELECT resource_id, assignment_status_id
4107: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records
4108: WHERE task_assignment_id = b_task_assignment_id;
4109:
4110: l_task_assignment_id NUMBER;
4111: l_assignee_role VARCHAR2(10);

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

4111: l_assignee_role VARCHAR2(10);
4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4117:
4118: if l_assignee_role = 'ASSIGNEE' then
4119: OPEN c_task_assignment(l_task_assignment_id);

Line 4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4117:
4118: if l_assignee_role = 'ASSIGNEE' then
4119: OPEN c_task_assignment(l_task_assignment_id);
4120: FETCH c_task_assignment INTO G_old_resource_id, g_old_tsk_asgn_sts_id;

Line 4155: jtf_task_assignments jta

4151:
4152: cursor get_blank_req_header is
4153: SELECT rh.requirement_header_id
4154: FROM csp_requirement_headers rh,
4155: jtf_task_assignments jta
4156: WHERE jta.task_assignment_id = l_task_assignment_id
4157: AND rh.task_id = jta.task_id
4158: AND rh.task_assignment_id IS NULL
4159: AND NOT EXISTS

Line 4187: jtf_task_assignments jta

4183: jtf_tasks_b jtb,
4184: hz_cust_site_uses_all hcsu,
4185: hz_cust_acct_sites_all hcas,
4186: po_location_associations_all pa,
4187: jtf_task_assignments jta
4188: WHERE jta.task_assignment_id = l_Task_Assignment_id
4189: AND jtb.task_id = jta.task_id
4190: AND jtb.source_object_type_code = 'SR'
4191: and jtb.source_object_id = cia.incident_id

Line 4217: jtf_task_assignments jta

4213: jtf_tasks_b jtb,
4214: hz_cust_site_uses_all hcsu,
4215: hz_cust_acct_sites_all hcas,
4216: po_location_associations_all pa,
4217: jtf_task_assignments jta
4218: WHERE jta.task_assignment_id = l_Task_Assignment_id
4219: AND jtb.task_id = jta.task_id
4220: AND jtb.source_object_type_code = 'SR'
4221: and jtb.source_object_id = cia.incident_id

Line 4239: jtf_task_assignments jta

4235: FROM csp_rs_ship_to_addresses_all_v csp,
4236: hz_cust_acct_sites_All hz,
4237: cs_incidents_all_b cs,
4238: jtf_tasks_b jtb,
4239: jtf_task_assignments jta
4240: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id
4241: AND csp.resource_id = jta.resource_id
4242: AND csp.resource_type = jta.resource_type_code
4243: AND primary_flag = 'Y'

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

4257: 'Begin');
4258: end if;
4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:

Line 4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

4258: end if;
4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4268: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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

4523: 'begin ...');
4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

Line 4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');