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

Line 763: FROM csi_ii_relationships

759:
760: IF l_instance_usage_code = 'IN_RELATIONSHIP' THEN
761: SELECT object_id
762: INTO l_parent_instance_id
763: FROM csi_ii_relationships
764: WHERE subject_id = p_instance_rec.instance_id
765: AND relationship_type_code = 'COMPONENT-OF'
766: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
767: AND nvl(active_end_date, sysdate+1);

Line 849: debug(' Inside API :csi_ii_relationships_pub.create_relationship');

845: l_ii_rltns_tbl(1).relationship_type_code := 'COMPONENT-OF';
846: l_ii_rltns_tbl(1).object_id := l_parent_instance_id;
847: l_ii_rltns_tbl(1).subject_id := l_copy_instance_tbl(c_ind).instance_id;
848:
849: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
850:
851: csi_ii_relationships_pub.create_relationship(
852: p_api_version => 1.0,
853: p_commit => fnd_api.g_false,

Line 851: csi_ii_relationships_pub.create_relationship(

847: l_ii_rltns_tbl(1).subject_id := l_copy_instance_tbl(c_ind).instance_id;
848:
849: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
850:
851: csi_ii_relationships_pub.create_relationship(
852: p_api_version => 1.0,
853: p_commit => fnd_api.g_false,
854: p_init_msg_list => fnd_api.g_true,
855: p_validation_level => fnd_api.g_valid_level_full,

Line 1080: FROM csi_ii_relationships

1076: IF l_instance_rec.instance_usage_code = 'IN_RELATIONSHIP' THEN
1077: BEGIN
1078: SELECT object_id
1079: INTO l_parent_instance_id
1080: FROM csi_ii_relationships
1081: WHERE subject_id = l_instance_rec.instance_id
1082: AND relationship_type_code = 'COMPONENT-OF';
1083: EXCEPTION
1084: WHEN no_data_found THEN

Line 1196: debug(' Inside API :csi_ii_relationships_pub.create_relationship');

1192: l_ii_rltns_tbl(1).relationship_type_code := 'COMPONENT-OF';
1193: l_ii_rltns_tbl(1).object_id := l_parent_instance_id;
1194: l_ii_rltns_tbl(1).subject_id := l_c_instance_rec.instance_id;
1195:
1196: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
1197:
1198: csi_ii_relationships_pub.create_relationship(
1199: p_api_version => 1.0,
1200: p_commit => fnd_api.g_false,

Line 1198: csi_ii_relationships_pub.create_relationship(

1194: l_ii_rltns_tbl(1).subject_id := l_c_instance_rec.instance_id;
1195:
1196: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
1197:
1198: csi_ii_relationships_pub.create_relationship(
1199: p_api_version => 1.0,
1200: p_commit => fnd_api.g_false,
1201: p_init_msg_list => fnd_api.g_true,
1202: p_validation_level => fnd_api.g_valid_level_full,

Line 3140: FROM csi_ii_relationships

3136: IF px_wip_instances(l_ind).instance_usage_code = 'IN_RELATIONSHIP' THEN
3137:
3138: SELECT object_id
3139: INTO l_parent_instance_id
3140: FROM csi_ii_relationships
3141: WHERE subject_id = px_wip_instances(l_ind).instance_id
3142: AND relationship_type_code = 'COMPONENT-OF'
3143: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
3144: AND nvl(active_end_date, sysdate+1);

Line 4071: csi_ii_relationships cir,

4067: SELECT cii_sub.instance_id,
4068: cii_sub.serial_number,
4069: cii_sub.location_type_code
4070: FROM csi_item_instances cii_obj,
4071: csi_ii_relationships cir,
4072: csi_item_instances cii_sub
4073: WHERE cii_obj.inventory_item_id = p_config_rec.item_id
4074: AND cii_obj.last_oe_order_line_id = p_config_rec.line_id
4075: AND cir.object_id = cii_obj.instance_id

Line 4428: csi_ii_relationships cir

4424:
4425: CURSOR option_inst_cur IS
4426: SELECT cii.instance_id
4427: FROM csi_item_instances cii,
4428: csi_ii_relationships cir
4429: WHERE cir.object_id = p_config_instance_id
4430: AND cir.relationship_type_code = 'COMPONENT-OF'
4431: AND cii.instance_id = cir.subject_id
4432: AND cii.inventory_item_id = p_option_item_id

Line 4634: FROM csi_ii_relationships

4630:
4631: IF nvl(p_relationship_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
4632: SELECT object_version_number
4633: INTO l_exp_rltns_rec.object_version_number
4634: FROM csi_ii_relationships
4635: WHERE relationship_id = l_exp_rltns_rec.relationship_id;
4636:
4637: debug(' relationship_ovn :'||l_exp_rltns_rec.object_version_number);
4638: csi_t_gen_utility_pvt.dump_api_info(

Line 4639: p_pkg_name => 'csi_ii_relationships_pub',

4635: WHERE relationship_id = l_exp_rltns_rec.relationship_id;
4636:
4637: debug(' relationship_ovn :'||l_exp_rltns_rec.object_version_number);
4638: csi_t_gen_utility_pvt.dump_api_info(
4639: p_pkg_name => 'csi_ii_relationships_pub',
4640: p_api_name => 'expire_relationship');
4641:
4642: csi_ii_relationships_pub.expire_relationship(
4643: p_api_version => 1.0,

Line 4642: csi_ii_relationships_pub.expire_relationship(

4638: csi_t_gen_utility_pvt.dump_api_info(
4639: p_pkg_name => 'csi_ii_relationships_pub',
4640: p_api_name => 'expire_relationship');
4641:
4642: csi_ii_relationships_pub.expire_relationship(
4643: p_api_version => 1.0,
4644: p_commit => fnd_api.g_false,
4645: p_init_msg_list => fnd_api.g_false,
4646: p_validation_level => fnd_api.g_valid_level_full,

Line 4692: p_pkg_name => 'csi_ii_relationships_pub',

4688: l_relationship_query_rec.subject_id := p_instance_id;
4689: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4690:
4691: csi_t_gen_utility_pvt.dump_api_info(
4692: p_pkg_name => 'csi_ii_relationships_pub',
4693: p_api_name => 'get_relationships');
4694:
4695: csi_ii_relationships_pub.get_relationships(
4696: p_api_version => 1.0,

Line 4695: csi_ii_relationships_pub.get_relationships(

4691: csi_t_gen_utility_pvt.dump_api_info(
4692: p_pkg_name => 'csi_ii_relationships_pub',
4693: p_api_name => 'get_relationships');
4694:
4695: csi_ii_relationships_pub.get_relationships(
4696: p_api_version => 1.0,
4697: p_commit => fnd_api.g_false,
4698: p_init_msg_list => fnd_api.g_true,
4699: p_validation_level => fnd_api.g_valid_level_full,

Line 4863: FROM csi_ii_relationships

4859: SELECT relationship_id,
4860: object_version_number
4861: INTO px_ii_rltns_tbl(px_new_ind).relationship_id,
4862: px_ii_rltns_tbl(px_new_ind).object_version_number
4863: FROM csi_ii_relationships
4864: WHERE object_id = px_ii_rltns_tbl(px_new_ind).object_id
4865: AND subject_id = px_ii_rltns_tbl(px_new_ind).subject_id
4866: AND relationship_type_code = 'COMPONENT-OF';
4867: EXCEPTION

Line 5013: FROM csi_ii_relationships

5009: SELECT relationship_id,
5010: object_version_number
5011: INTO l_ii_rltns_tbl(l_ind).relationship_id,
5012: l_ii_rltns_tbl(l_ind).object_version_number
5013: FROM csi_ii_relationships
5014: WHERE subject_id = l_wip_instances(w_ind).instance_id
5015: AND relationship_type_code = 'COMPONENT-OF'
5016: AND sysdate between nvl(active_start_date, sysdate-1)
5017: and nvl(active_end_date, sysdate+1);

Line 5485: csi_ii_relationships cir

5481: SELECT cir.subject_id,
5482: cir.relationship_id,
5483: cir.object_version_number
5484: FROM csi_item_instances cii_sub,
5485: csi_ii_relationships cir
5486: WHERE cir.object_id = p_top_config_instance_id
5487: AND cir.relationship_type_code = 'COMPONENT-OF'
5488: AND sysdate between nvl(cir.active_start_date, sysdate-1)
5489: and nvl(cir.active_end_date, sysdate+1)

Line 5930: p_pkg_name => 'csi_ii_relationships_pub',

5926: l_ii_rltns_qry_rec.object_id := l_config_instances(ci_ind).instance_id;
5927: l_ii_rltns_qry_rec.relationship_type_code := 'COMPONENT-OF';
5928:
5929: csi_t_gen_utility_pvt.dump_api_info(
5930: p_pkg_name => 'csi_ii_relationships_pub',
5931: p_api_name => 'get_relationships');
5932:
5933: csi_ii_relationships_pub.get_relationships(
5934: p_api_version => 1.0,

Line 5933: csi_ii_relationships_pub.get_relationships(

5929: csi_t_gen_utility_pvt.dump_api_info(
5930: p_pkg_name => 'csi_ii_relationships_pub',
5931: p_api_name => 'get_relationships');
5932:
5933: csi_ii_relationships_pub.get_relationships(
5934: p_api_version => 1.0,
5935: p_commit => fnd_api.g_false,
5936: p_init_msg_list => fnd_api.g_true,
5937: p_validation_level => fnd_api.g_valid_level_full,

Line 7326: p_pkg_name => 'csi_ii_relationships_pub',

7322:
7323: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7324:
7325: csi_t_gen_utility_pvt.dump_api_info(
7326: p_pkg_name => 'csi_ii_relationships_pub',
7327: p_api_name => 'create_relationship');
7328:
7329: csi_ii_relationships_pub.create_relationship(
7330: p_api_version => 1.0,

Line 7329: csi_ii_relationships_pub.create_relationship(

7325: csi_t_gen_utility_pvt.dump_api_info(
7326: p_pkg_name => 'csi_ii_relationships_pub',
7327: p_api_name => 'create_relationship');
7328:
7329: csi_ii_relationships_pub.create_relationship(
7330: p_api_version => 1.0,
7331: p_commit => fnd_api.g_false,
7332: p_init_msg_list => fnd_api.g_true,
7333: p_validation_level => fnd_api.g_valid_level_full,

Line 7372: csi_ii_relationships cir

7368: SELECT cii.instance_id,
7369: cir.relationship_id,
7370: cir.object_version_number
7371: FROM csi_item_instances cii,
7372: csi_ii_relationships cir
7373: WHERE cir.object_id = p_config_instance_id
7374: AND cir.relationship_type_code = 'COMPONENT-OF'
7375: AND cii.instance_id = cir.subject_id
7376: AND cii.inventory_item_id = p_class_item_id;

Line 7474: p_pkg_name => 'csi_ii_relationships_pub',

7470: debug(' subject_id : '||l_ii_rltns_qry_rec.subject_id);
7471: debug(' relationship_type : '||l_ii_rltns_qry_rec.relationship_type_code);
7472:
7473: csi_t_gen_utility_pvt.dump_api_info(
7474: p_pkg_name => 'csi_ii_relationships_pub',
7475: p_api_name => 'get_relationships');
7476:
7477: csi_ii_relationships_pub.get_relationships(
7478: p_api_version => 1.0,

Line 7477: csi_ii_relationships_pub.get_relationships(

7473: csi_t_gen_utility_pvt.dump_api_info(
7474: p_pkg_name => 'csi_ii_relationships_pub',
7475: p_api_name => 'get_relationships');
7476:
7477: csi_ii_relationships_pub.get_relationships(
7478: p_api_version => 1.0,
7479: p_commit => fnd_api.g_false,
7480: p_init_msg_list => fnd_api.g_true,
7481: p_validation_level => fnd_api.g_valid_level_full,

Line 7840: p_pkg_name => 'csi_ii_relationships_pub',

7836:
7837: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7838:
7839: csi_t_gen_utility_pvt.dump_api_info(
7840: p_pkg_name => 'csi_ii_relationships_pub',
7841: p_api_name => 'create_relationship');
7842:
7843: csi_ii_relationships_pub.create_relationship(
7844: p_api_version => 1.0,

Line 7843: csi_ii_relationships_pub.create_relationship(

7839: csi_t_gen_utility_pvt.dump_api_info(
7840: p_pkg_name => 'csi_ii_relationships_pub',
7841: p_api_name => 'create_relationship');
7842:
7843: csi_ii_relationships_pub.create_relationship(
7844: p_api_version => 1.0,
7845: p_commit => fnd_api.g_false,
7846: p_init_msg_list => fnd_api.g_true,
7847: p_validation_level => fnd_api.g_valid_level_full,