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 CSP_INV_LOC_ASSIGNMENTS

Line 821: csp_INV_LOC_ASSIGNMENTS cla

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)
825: and jta.task_assignment_id(+) = crh.task_assignment_id

Line 1555: FROM CSP_INV_LOC_ASSIGNMENTS

1551:
1552: BEGIN
1553: SELECT organization_id, subinventory_code
1554: INTO l_header_rec.dest_organization_id, l_header_rec.dest_subinventory
1555: FROM CSP_INV_LOC_ASSIGNMENTS
1556: WHERE resource_id = l_header_rec.resource_id
1557: AND resource_type = l_header_rec.resource_type
1558: AND default_code = 'IN';
1559: EXCEPTION

Line 2650: FROM csp_inv_loc_assignments

2646: AND primary_flag = 'Y';
2647:
2648: CURSOR get_Resource_org_sub IS
2649: SELECT organization_id, subinventory_code
2650: FROM csp_inv_loc_assignments
2651: WHERE resource_id = l_resource_id
2652: AND resource_type = l_resource_type_code
2653: AND default_code = 'IN';
2654: