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 3179: FROM csi_ii_relationships ciir,

3175: px_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl)
3176: IS
3177: CURSOR iir_cur(p_object_id in number, p_item_id in number) IS
3178: SELECT cii.quantity alloc_quantity
3179: FROM csi_ii_relationships ciir,
3180: csi_item_instances cii
3181: WHERE ciir.object_id = p_object_id
3182: AND cii.instance_id = ciir.subject_id
3183: AND cii.inventory_item_id = p_item_id

Line 4406: FROM csi_ii_relationships

4402:
4403: CURSOR new_transfer_comp(p_instance_id IN NUMBER) IS
4404: SELECT relationship_id, object_version_number,
4405: subject_id, object_id, relationship_type_code
4406: FROM csi_ii_relationships
4407: WHERE object_id = p_instance_id
4408: AND relationship_type_code = 'COMPONENT-OF'
4409: AND (active_end_date is null OR active_end_date >= sysdate);
4410:

Line 4413: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir

4409: AND (active_end_date is null OR active_end_date >= sysdate);
4410:
4411: CURSOR check_instance_status(p_instance_id IN NUMBER) IS
4412: SELECT distinct instance_number
4413: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir
4414: WHERE owner_party_id NOT IN (SELECT internal_party_id
4415: FROM csi_install_parameters)
4416: AND (cii.instance_id = cir.object_id or cii.instance_id = cir.subject_id)
4417: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 4432: FROM csi_ii_relationships

4428:
4429: CURSOR rmarp_transfer_comp(p_instance_id IN NUMBER) IS
4430: SELECT relationship_id, object_version_number,
4431: subject_id, object_id, relationship_type_code
4432: FROM csi_ii_relationships
4433: WHERE object_id = p_instance_id
4434: AND relationship_type_code = 'COMPONENT-OF';
4435:
4436: CURSOR check_item_status_validity(p_instance_id IN NUMBER) IS

Line 4438: FROM csi_ii_relationships

4434: AND relationship_type_code = 'COMPONENT-OF';
4435:
4436: CURSOR check_item_status_validity(p_instance_id IN NUMBER) IS
4437: SELECT 'RMA' item_status
4438: FROM csi_ii_relationships
4439: WHERE subject_id = p_instance_id
4440: AND relationship_type_code = 'COMPONENT-OF'
4441: AND (active_end_date IS NOT NULL OR active_end_date <= sysdate)
4442: ORDER BY RELATIONSHIP_ID DESC;

Line 4453: FROM csi_ii_relationships

4449: AND active_end_date IS NULL;
4450:
4451: CURSOR chk_item_config(p_instance_id IN NUMBER) IS
4452: SELECT 'Y' config_instance, active_end_date
4453: FROM csi_ii_relationships
4454: WHERE subject_id = p_instance_id
4455: AND relationship_type_code = 'COMPONENT-OF'
4456: ORDER BY relationship_id DESC;
4457: BEGIN

Line 4819: FROM csi_ii_relationships

4815: /* Check if item being replaced is in the same configuration */
4816: BEGIN
4817: SELECT 'x'
4818: INTO l_found
4819: FROM csi_ii_relationships
4820: WHERE subject_id = l_old_instance_id
4821: AND object_id = l_parent_instance_id;
4822: EXCEPTION
4823: WHEN NO_DATA_FOUND THEN

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

4919:
4920: debug('Trf Comp After BOM Check = '||l_transfer_components_flag);
4921: IF l_transfer_components_flag = 'Y' THEN
4922: debug('New Instance Id = '||to_char(l_new_instance_id));
4923: /* Check for csi_ii_relationships(item being shipped) */
4924: BEGIN
4925: SELECT 'N'
4926: INTO l_transfer_components_flag
4927: FROM csi_ii_relationships

Line 4927: FROM csi_ii_relationships

4923: /* Check for csi_ii_relationships(item being shipped) */
4924: BEGIN
4925: SELECT 'N'
4926: INTO l_transfer_components_flag
4927: FROM csi_ii_relationships
4928: WHERE object_id = l_new_instance_id
4929: AND relationship_type_code = 'COMPONENT-OF'
4930: AND active_end_date IS NULL;
4931: EXCEPTION

Line 4982: FROM csi_ii_relationships

4978: SELECT relationship_id, object_version_number,
4979: object_id, relationship_type_code
4980: INTO l_relationship_id, l_ii_rel_obj_ver_num,
4981: l_expire_object_id, l_relationship_type_code
4982: FROM csi_ii_relationships
4983: WHERE subject_id = l_old_instance_id
4984: AND relationship_type_code = 'COMPONENT-OF'
4985: AND (active_end_date is null OR active_end_date > sysdate);
4986:

Line 5041: FROM csi_ii_relationships

5037: SELECT relationship_id, object_version_number,
5038: object_id, relationship_type_code
5039: INTO l_relationship_id, l_object_version_number,
5040: l_object_id, l_relationship_type_code
5041: FROM csi_ii_relationships
5042: WHERE subject_id = l_old_instance_id
5043: AND object_id = l_parent_instance_id
5044: AND relationship_type_code = 'COMPONENT-OF'
5045: AND (active_end_date IS NOT NULL OR active_end_date <= sysdate);

Line 6046: csi_ii_relationships_pub.get_relationships (

6042: debug('l_relationship_query_rec.object_id :'|| l_relationship_query_rec.object_id);
6043: debug('l_relationship_query_rec.subject_id :'|| l_relationship_query_rec.subject_id);
6044: debug('l_relationship_query_rec.relationship_type_code :'|| l_relationship_query_rec.relationship_type_code);
6045:
6046: csi_ii_relationships_pub.get_relationships (
6047: p_api_version => 1.0 ,
6048: p_commit => fnd_api.g_false,
6049: p_init_msg_list => fnd_api.g_false,
6050: p_validation_level => fnd_api.g_valid_level_full,

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

6058: x_msg_data => x_msg_data) ;
6059:
6060: IF NOT(x_return_status = fnd_api.g_ret_sts_success)
6061: THEN
6062: debug('csi_ii_relationships_pub.get_relationships call failed :'||
6063: x_msg_data);
6064: RAISE fnd_api.g_exc_error;
6065: END IF;
6066: IF l_ii_relationship_tbl.count > 0

Line 6896: FROM csi_ii_relationships

6892:
6893: --fix for bug4607042
6894: CURSOR rel_build_cur(p_instance_id IN NUMBER) IS
6895: SELECT 'X'
6896: FROM csi_ii_relationships
6897: WHERE subject_id = p_instance_id
6898: AND relationship_type_code = 'COMPONENT-OF'
6899: AND active_end_date IS NULL;
6900: --end of fix bug4607042