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.CSI_UTL_PKG dependencies on CSI_II_RELATIONSHIPS

Line 132: FROM csi_ii_relationships

128: api_log('get_ii_obj_ver_num');
129:
130: SELECT object_version_number
131: INTO l_obj_ver_num
132: FROM csi_ii_relationships
133: WHERE relationship_id = p_relationship_id
134: AND ((active_end_date is null ) OR
135: (active_end_date > sysdate));
136:

Line 1312: FROM csi_ii_relationships

1308: api_log('check_relation_exist');
1309:
1310: SELECT 'x'
1311: INTO l_dummy
1312: FROM csi_ii_relationships
1313: WHERE object_id = p_model_line_id
1314: AND subject_id = p_line_id
1315: AND ((active_end_date is null ) OR
1316: (active_end_date > sysdate));

Line 1967: FROM csi_ii_relationships

1963: object_id,
1964: subject_id
1965: INTO x_object_id,
1966: x_subject_id
1967: FROM csi_ii_relationships
1968: WHERE relationship_id = p_ii_relationship_id
1969: AND ((active_end_date is null) OR
1970: (active_end_date > sysdate));
1971:

Line 2264: FROM csi_ii_relationships

2260: l_instance_usage_code VARCHAR2(30);
2261:
2262: CURSOR rltns_cur(pc_instance_id IN number) IS
2263: SELECT subject_id
2264: FROM csi_ii_relationships
2265: WHERE object_id = pc_instance_id -- parent instance id
2266: AND relationship_type_code = 'COMPONENT-OF'
2267: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
2268: AND nvl(active_end_date , sysdate+1);

Line 3221: FROM csi_ii_relationships ciir,

3217: px_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl)
3218: IS
3219: CURSOR iir_cur(p_object_id in number, p_item_id in number) IS
3220: SELECT cii.quantity alloc_quantity
3221: FROM csi_ii_relationships ciir,
3222: csi_item_instances cii
3223: WHERE ciir.object_id = p_object_id
3224: AND cii.instance_id = ciir.subject_id
3225: AND cii.inventory_item_id = p_item_id

Line 4448: FROM csi_ii_relationships

4444:
4445: CURSOR new_transfer_comp(p_instance_id IN NUMBER) IS
4446: SELECT relationship_id, object_version_number,
4447: subject_id, object_id, relationship_type_code
4448: FROM csi_ii_relationships
4449: WHERE object_id = p_instance_id
4450: AND relationship_type_code = 'COMPONENT-OF'
4451: AND (active_end_date is null OR active_end_date >= sysdate);
4452:

Line 4455: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir

4451: AND (active_end_date is null OR active_end_date >= sysdate);
4452:
4453: CURSOR check_instance_status(p_instance_id IN NUMBER) IS
4454: SELECT distinct instance_number
4455: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir
4456: WHERE owner_party_id NOT IN (SELECT internal_party_id
4457: FROM csi_install_parameters)
4458: AND (cii.instance_id = cir.object_id or cii.instance_id = cir.subject_id)
4459: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 4474: FROM csi_ii_relationships

4470:
4471: CURSOR rmarp_transfer_comp(p_instance_id IN NUMBER) IS
4472: SELECT relationship_id, object_version_number,
4473: subject_id, object_id, relationship_type_code
4474: FROM csi_ii_relationships
4475: WHERE object_id = p_instance_id
4476: AND relationship_type_code = 'COMPONENT-OF';
4477:
4478: CURSOR check_item_status_validity(p_instance_id IN NUMBER) IS

Line 4480: FROM csi_ii_relationships

4476: AND relationship_type_code = 'COMPONENT-OF';
4477:
4478: CURSOR check_item_status_validity(p_instance_id IN NUMBER) IS
4479: SELECT 'RMA' item_status
4480: FROM csi_ii_relationships
4481: WHERE subject_id = p_instance_id
4482: AND relationship_type_code = 'COMPONENT-OF'
4483: AND (active_end_date IS NOT NULL OR active_end_date <= sysdate)
4484: ORDER BY RELATIONSHIP_ID DESC;

Line 4495: FROM csi_ii_relationships

4491: AND active_end_date IS NULL;
4492:
4493: CURSOR chk_item_config(p_instance_id IN NUMBER) IS
4494: SELECT 'Y' config_instance, active_end_date
4495: FROM csi_ii_relationships
4496: WHERE subject_id = p_instance_id
4497: AND relationship_type_code = 'COMPONENT-OF'
4498: ORDER BY relationship_id DESC;
4499: BEGIN

Line 4861: FROM csi_ii_relationships

4857: /* Check if item being replaced is in the same configuration */
4858: BEGIN
4859: SELECT 'x'
4860: INTO l_found
4861: FROM csi_ii_relationships
4862: WHERE subject_id = l_old_instance_id
4863: AND object_id = l_parent_instance_id;
4864: EXCEPTION
4865: WHEN NO_DATA_FOUND THEN

Line 4965: /* Check for csi_ii_relationships(item being shipped) */

4961:
4962: debug('Trf Comp After BOM Check = '||l_transfer_components_flag);
4963: IF l_transfer_components_flag = 'Y' THEN
4964: debug('New Instance Id = '||to_char(l_new_instance_id));
4965: /* Check for csi_ii_relationships(item being shipped) */
4966: BEGIN
4967: SELECT 'N'
4968: INTO l_transfer_components_flag
4969: FROM csi_ii_relationships

Line 4969: FROM csi_ii_relationships

4965: /* Check for csi_ii_relationships(item being shipped) */
4966: BEGIN
4967: SELECT 'N'
4968: INTO l_transfer_components_flag
4969: FROM csi_ii_relationships
4970: WHERE object_id = l_new_instance_id
4971: AND relationship_type_code = 'COMPONENT-OF'
4972: AND active_end_date IS NULL;
4973: EXCEPTION

Line 5024: FROM csi_ii_relationships

5020: SELECT relationship_id, object_version_number,
5021: object_id, relationship_type_code
5022: INTO l_relationship_id, l_ii_rel_obj_ver_num,
5023: l_expire_object_id, l_relationship_type_code
5024: FROM csi_ii_relationships
5025: WHERE subject_id = l_old_instance_id
5026: AND relationship_type_code = 'COMPONENT-OF'
5027: AND object_id = l_parent_instance_id; -- Added for bug 14163453
5028: --AND (active_end_date is null OR active_end_date > sysdate); -- commented for bug 14163453

Line 5085: FROM csi_ii_relationships

5081: SELECT relationship_id, object_version_number,
5082: object_id, relationship_type_code
5083: INTO l_relationship_id, l_object_version_number,
5084: l_object_id, l_relationship_type_code
5085: FROM csi_ii_relationships
5086: WHERE subject_id = l_old_instance_id
5087: AND object_id = l_parent_instance_id
5088: AND relationship_type_code = 'COMPONENT-OF'
5089: AND (active_end_date IS NOT NULL OR active_end_date <= sysdate);

Line 6125: csi_ii_relationships_pub.get_relationships (

6121: debug('l_relationship_query_rec.object_id :'|| l_relationship_query_rec.object_id);
6122: debug('l_relationship_query_rec.subject_id :'|| l_relationship_query_rec.subject_id);
6123: debug('l_relationship_query_rec.relationship_type_code :'|| l_relationship_query_rec.relationship_type_code);
6124:
6125: csi_ii_relationships_pub.get_relationships (
6126: p_api_version => 1.0 ,
6127: p_commit => fnd_api.g_false,
6128: p_init_msg_list => fnd_api.g_false,
6129: p_validation_level => fnd_api.g_valid_level_full,

Line 6141: debug('csi_ii_relationships_pub.get_relationships call failed :'||

6137: x_msg_data => x_msg_data) ;
6138:
6139: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
6140: THEN
6141: debug('csi_ii_relationships_pub.get_relationships call failed :'||
6142: x_msg_data);
6143: RAISE fnd_api.g_exc_error;
6144: END IF;
6145: IF l_ii_relationship_tbl.count > 0

Line 6984: FROM csi_ii_relationships

6980:
6981: --fix for bug4607042
6982: CURSOR rel_build_cur(p_instance_id IN NUMBER) IS
6983: SELECT 'X'
6984: FROM csi_ii_relationships
6985: WHERE subject_id = p_instance_id
6986: AND relationship_type_code = 'COMPONENT-OF'
6987: AND active_end_date IS NULL;
6988: --end of fix bug4607042