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_WIP_TRXS_PKG dependencies on CSI_II_RELATIONSHIPS

Line 2073: FROM csi_ii_relationships

2069: l_rltn_exists := 'N';
2070:
2071: SELECT 'Y'
2072: INTO l_rltn_exists
2073: FROM csi_ii_relationships
2074: WHERE subject_id = p_assy_comp_map_tbl(l_ind).comp_instance_id
2075: AND object_id = p_assy_comp_map_tbl(l_ind).assy_instance_id
2076: AND relationship_type_code = 'COMPONENT-OF'
2077: AND active_end_date is NULL OR active_end_date > sysdate;

Line 2097: p_pkg_name => 'csi_ii_relationships_pub',

2093: END LOOP;
2094: END IF;
2095:
2096: api_log(
2097: p_pkg_name => 'csi_ii_relationships_pub',
2098: p_api_name => 'create_relationship');
2099:
2100: csi_ii_relationships_pub.create_relationship(
2101: p_api_version => 1.0,

Line 2100: csi_ii_relationships_pub.create_relationship(

2096: api_log(
2097: p_pkg_name => 'csi_ii_relationships_pub',
2098: p_api_name => 'create_relationship');
2099:
2100: csi_ii_relationships_pub.create_relationship(
2101: p_api_version => 1.0,
2102: p_commit => fnd_api.g_false,
2103: p_init_msg_list => fnd_api.g_true,
2104: p_validation_level => fnd_api.g_valid_level_full,

Line 2112: debug('Error in csi_ii_relationships_pub.create_relationship.');

2108: x_msg_count => l_msg_count,
2109: x_msg_data => l_msg_data);
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2112: debug('Error in csi_ii_relationships_pub.create_relationship.');
2113: RAISE fnd_api.g_exc_error;
2114: END IF;
2115:
2116:

Line 2306: FROM csi_ii_relationships cir,

2302: l_alloc_count number := 0;
2303: BEGIN
2304: SELECT count(*)
2305: INTO l_alloc_count
2306: FROM csi_ii_relationships cir,
2307: csi_item_instances cii
2308: WHERE cir.object_id = p_object_id
2309: AND cir.relationship_type_code = 'COMPONENT-OF'
2310: AND sysdate BETWEEN nvl(cir.active_start_date, sysdate-1)

Line 2489: FROM csi_ii_relationships cir,

2485: IS
2486:
2487: CURSOR comp_cur (p_object_id in number, p_comp_item_id in number) IS
2488: SELECT cir.subject_id, cii.quantity
2489: FROM csi_ii_relationships cir,
2490: csi_item_instances cii
2491: WHERE cir.object_id = p_object_id
2492: AND cir.relationship_type_code = 'COMPONENT-OF'
2493: AND cii.instance_id = cir.subject_id

Line 2538: FROM csi_ii_relationships cir,

2534: l_alloc_qty number := 0;
2535: BEGIN
2536: SELECT sum(cii.quantity)
2537: INTO l_alloc_qty
2538: FROM csi_ii_relationships cir,
2539: csi_item_instances cii
2540: WHERE cir.object_id = p_object_id
2541: AND cir.relationship_type_code = 'COMPONENT-OF'
2542: AND cii.instance_id = cir.subject_id

Line 2982: FROM csi_ii_relationships cir,

2978: IS
2979:
2980: CURSOR rltns_cur(p_parent_instance_id IN number) IS
2981: SELECT cir.subject_id, cii.quantity
2982: FROM csi_ii_relationships cir,
2983: csi_item_instances cii
2984: WHERE cir.object_id = p_parent_instance_id
2985: AND cir.relationship_type_code = 'COMPONENT-OF'
2986: AND cii.instance_id = cir.subject_id

Line 5010: FROM csi_ii_relationships

5006: LOOP
5007: BEGIN
5008: SELECT object_id
5009: INTO l_inst_tbl(l_ind).attribute1
5010: FROM csi_ii_relationships
5011: WHERE subject_id = l_inst_tbl(l_ind).instance_id
5012: AND relationship_type_code = 'COMPONENT-OF';
5013: EXCEPTION
5014: WHEN no_data_found THEN

Line 5460: FROM csi_ii_relationships

5456: -- check if it is in a relation
5457: BEGIN
5458: SELECT 'Y', object_id
5459: INTO l_relation_found , l_parent_instance_id
5460: FROM csi_ii_relationships
5461: WHERE subject_id = l_instances_tbl(1).instance_id
5462: AND relationship_type_code = 'COMPONENT-OF'
5463: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
5464: AND nvl(active_end_date, sysdate+1);

Line 5503: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir

5499:
5500: BEGIN
5501: select cir.subject_id,ci2.quantity
5502: into l_instance_id, l_quantity
5503: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir
5504: where ci1.instance_id = cir.object_id
5505: and ci1.inventory_item_id = l_inv_item_id
5506: and ci1.serial_number = l_serial_number
5507: and ci2.inventory_item_id = p_mmt_rec.inventory_item_id

Line 6473: FROM csi_ii_relationships

6469: SELECT relationship_id,
6470: object_version_number
6471: INTO l_iir_rec.relationship_id,
6472: l_iir_rec.object_version_number
6473: FROM csi_ii_relationships
6474: WHERE object_id = l_obj_instance_id
6475: AND subject_id = l_sub_instance_id;
6476: EXCEPTION
6477: WHEN no_data_found THEN

Line 6645: p_pkg_name => 'csi_ii_relationships_pub',

6641: debug('create_relationship.COUNT :'||l_c_iir_tbl.COUNT);
6642:
6643: IF l_c_iir_tbl.COUNT > 0 THEN
6644: api_log(
6645: p_pkg_name => 'csi_ii_relationships_pub',
6646: p_api_name => 'create_relationship');
6647:
6648: csi_ii_relationships_pub.create_relationship(
6649: p_api_version => 1.0,

Line 6648: csi_ii_relationships_pub.create_relationship(

6644: api_log(
6645: p_pkg_name => 'csi_ii_relationships_pub',
6646: p_api_name => 'create_relationship');
6647:
6648: csi_ii_relationships_pub.create_relationship(
6649: p_api_version => 1.0,
6650: p_commit => fnd_api.g_false,
6651: p_init_msg_list => fnd_api.g_true,
6652: p_validation_level => fnd_api.g_valid_level_full,

Line 6668: p_pkg_name => 'csi_ii_relationships_pub',

6664: debug('update_relationship.COUNT :'||l_u_iir_tbl.COUNT);
6665:
6666: IF l_u_iir_tbl.COUNT > 0 THEN
6667: api_log(
6668: p_pkg_name => 'csi_ii_relationships_pub',
6669: p_api_name => 'update_relationship');
6670:
6671: debug('No code here yet for update relationship...');
6672:

Line 6864: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');

6860: debug('total components : '||l_ii_rltns_tbl.COUNT);
6861:
6862: IF l_ii_rltns_tbl.COUNT > 0 THEN
6863:
6864: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
6865:
6866: csi_ii_relationships_pub.create_relationship(
6867: p_api_version => 1.0,
6868: p_commit => fnd_api.g_false,

Line 6866: csi_ii_relationships_pub.create_relationship(

6862: IF l_ii_rltns_tbl.COUNT > 0 THEN
6863:
6864: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
6865:
6866: csi_ii_relationships_pub.create_relationship(
6867: p_api_version => 1.0,
6868: p_commit => fnd_api.g_false,
6869: p_init_msg_list => fnd_api.g_true,
6870: p_validation_level => fnd_api.g_valid_level_full,