APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 836: csp_INV_LOC_ASSIGNMENTS cla

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

Line 1669: FROM CSP_INV_LOC_ASSIGNMENTS

1665:
1666: BEGIN
1667: SELECT organization_id, subinventory_code
1668: INTO l_header_rec.dest_organization_id, l_header_rec.dest_subinventory
1669: FROM CSP_INV_LOC_ASSIGNMENTS
1670: WHERE resource_id = l_header_rec.resource_id
1671: AND resource_type = l_header_rec.resource_type
1672: AND default_code = 'IN';
1673: EXCEPTION

Line 2782: FROM csp_inv_loc_assignments

2778: AND csp.resource_type = l_resource_type_code;
2779:
2780: CURSOR get_Resource_org_sub IS
2781: SELECT organization_id, subinventory_code
2782: FROM csp_inv_loc_assignments
2783: WHERE resource_id = l_resource_id
2784: AND resource_type = l_resource_type_code
2785: AND default_code = 'IN';
2786:

Line 4168: FROM csp_inv_loc_assignments

4164: AND rl.requirement_header_id = rh.requirement_header_id);
4165:
4166: CURSOR get_Resource_org_sub IS
4167: SELECT organization_id, subinventory_code
4168: FROM csp_inv_loc_assignments
4169: WHERE resource_id = l_resource_id
4170: AND resource_type = l_resource_type_code
4171: AND default_code = 'IN';
4172: