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 723: FROM csi_ii_relationships

719:
720: IF l_instance_usage_code = 'IN_RELATIONSHIP' THEN
721: SELECT object_id
722: INTO l_parent_instance_id
723: FROM csi_ii_relationships
724: WHERE subject_id = p_instance_rec.instance_id
725: AND relationship_type_code = 'COMPONENT-OF'
726: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
727: AND nvl(active_end_date, sysdate+1);

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

805: l_ii_rltns_tbl(1).relationship_type_code := 'COMPONENT-OF';
806: l_ii_rltns_tbl(1).object_id := l_parent_instance_id;
807: l_ii_rltns_tbl(1).subject_id := l_copy_instance_tbl(c_ind).instance_id;
808:
809: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
810:
811: csi_ii_relationships_pub.create_relationship(
812: p_api_version => 1.0,
813: p_commit => fnd_api.g_false,

Line 811: csi_ii_relationships_pub.create_relationship(

807: l_ii_rltns_tbl(1).subject_id := l_copy_instance_tbl(c_ind).instance_id;
808:
809: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
810:
811: csi_ii_relationships_pub.create_relationship(
812: p_api_version => 1.0,
813: p_commit => fnd_api.g_false,
814: p_init_msg_list => fnd_api.g_true,
815: p_validation_level => fnd_api.g_valid_level_full,

Line 1040: FROM csi_ii_relationships

1036: IF l_instance_rec.instance_usage_code = 'IN_RELATIONSHIP' THEN
1037: BEGIN
1038: SELECT object_id
1039: INTO l_parent_instance_id
1040: FROM csi_ii_relationships
1041: WHERE subject_id = l_instance_rec.instance_id
1042: AND relationship_type_code = 'COMPONENT-OF';
1043: EXCEPTION
1044: WHEN no_data_found THEN

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

1152: l_ii_rltns_tbl(1).relationship_type_code := 'COMPONENT-OF';
1153: l_ii_rltns_tbl(1).object_id := l_parent_instance_id;
1154: l_ii_rltns_tbl(1).subject_id := l_c_instance_rec.instance_id;
1155:
1156: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
1157:
1158: csi_ii_relationships_pub.create_relationship(
1159: p_api_version => 1.0,
1160: p_commit => fnd_api.g_false,

Line 1158: csi_ii_relationships_pub.create_relationship(

1154: l_ii_rltns_tbl(1).subject_id := l_c_instance_rec.instance_id;
1155:
1156: debug(' Inside API :csi_ii_relationships_pub.create_relationship');
1157:
1158: csi_ii_relationships_pub.create_relationship(
1159: p_api_version => 1.0,
1160: p_commit => fnd_api.g_false,
1161: p_init_msg_list => fnd_api.g_true,
1162: p_validation_level => fnd_api.g_valid_level_full,

Line 3094: FROM csi_ii_relationships

3090: IF px_wip_instances(l_ind).instance_usage_code = 'IN_RELATIONSHIP' THEN
3091:
3092: SELECT object_id
3093: INTO l_parent_instance_id
3094: FROM csi_ii_relationships
3095: WHERE subject_id = px_wip_instances(l_ind).instance_id
3096: AND relationship_type_code = 'COMPONENT-OF'
3097: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
3098: AND nvl(active_end_date, sysdate+1);

Line 4023: csi_ii_relationships cir,

4019: SELECT cii_sub.instance_id,
4020: cii_sub.serial_number,
4021: cii_sub.location_type_code
4022: FROM csi_item_instances cii_obj,
4023: csi_ii_relationships cir,
4024: csi_item_instances cii_sub
4025: WHERE cii_obj.inventory_item_id = p_config_rec.item_id
4026: AND cii_obj.last_oe_order_line_id = p_config_rec.line_id
4027: AND cir.object_id = cii_obj.instance_id

Line 4380: csi_ii_relationships cir

4376:
4377: CURSOR option_inst_cur IS
4378: SELECT cii.instance_id
4379: FROM csi_item_instances cii,
4380: csi_ii_relationships cir
4381: WHERE cir.object_id = p_config_instance_id
4382: AND cir.relationship_type_code = 'COMPONENT-OF'
4383: AND cii.instance_id = cir.subject_id
4384: AND cii.inventory_item_id = p_option_item_id

Line 4586: FROM csi_ii_relationships

4582:
4583: IF nvl(p_relationship_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
4584: SELECT object_version_number
4585: INTO l_exp_rltns_rec.object_version_number
4586: FROM csi_ii_relationships
4587: WHERE relationship_id = l_exp_rltns_rec.relationship_id;
4588:
4589: debug(' relationship_ovn :'||l_exp_rltns_rec.object_version_number);
4590: csi_t_gen_utility_pvt.dump_api_info(

Line 4591: p_pkg_name => 'csi_ii_relationships_pub',

4587: WHERE relationship_id = l_exp_rltns_rec.relationship_id;
4588:
4589: debug(' relationship_ovn :'||l_exp_rltns_rec.object_version_number);
4590: csi_t_gen_utility_pvt.dump_api_info(
4591: p_pkg_name => 'csi_ii_relationships_pub',
4592: p_api_name => 'expire_relationship');
4593:
4594: csi_ii_relationships_pub.expire_relationship(
4595: p_api_version => 1.0,

Line 4594: csi_ii_relationships_pub.expire_relationship(

4590: csi_t_gen_utility_pvt.dump_api_info(
4591: p_pkg_name => 'csi_ii_relationships_pub',
4592: p_api_name => 'expire_relationship');
4593:
4594: csi_ii_relationships_pub.expire_relationship(
4595: p_api_version => 1.0,
4596: p_commit => fnd_api.g_false,
4597: p_init_msg_list => fnd_api.g_false,
4598: p_validation_level => fnd_api.g_valid_level_full,

Line 4644: p_pkg_name => 'csi_ii_relationships_pub',

4640: l_relationship_query_rec.subject_id := p_instance_id;
4641: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4642:
4643: csi_t_gen_utility_pvt.dump_api_info(
4644: p_pkg_name => 'csi_ii_relationships_pub',
4645: p_api_name => 'get_relationships');
4646:
4647: csi_ii_relationships_pub.get_relationships(
4648: p_api_version => 1.0,

Line 4647: csi_ii_relationships_pub.get_relationships(

4643: csi_t_gen_utility_pvt.dump_api_info(
4644: p_pkg_name => 'csi_ii_relationships_pub',
4645: p_api_name => 'get_relationships');
4646:
4647: csi_ii_relationships_pub.get_relationships(
4648: p_api_version => 1.0,
4649: p_commit => fnd_api.g_false,
4650: p_init_msg_list => fnd_api.g_true,
4651: p_validation_level => fnd_api.g_valid_level_full,

Line 4815: FROM csi_ii_relationships

4811: SELECT relationship_id,
4812: object_version_number
4813: INTO px_ii_rltns_tbl(px_new_ind).relationship_id,
4814: px_ii_rltns_tbl(px_new_ind).object_version_number
4815: FROM csi_ii_relationships
4816: WHERE object_id = px_ii_rltns_tbl(px_new_ind).object_id
4817: AND subject_id = px_ii_rltns_tbl(px_new_ind).subject_id
4818: AND relationship_type_code = 'COMPONENT-OF';
4819: EXCEPTION

Line 4965: FROM csi_ii_relationships

4961: SELECT relationship_id,
4962: object_version_number
4963: INTO l_ii_rltns_tbl(l_ind).relationship_id,
4964: l_ii_rltns_tbl(l_ind).object_version_number
4965: FROM csi_ii_relationships
4966: WHERE subject_id = l_wip_instances(w_ind).instance_id
4967: AND relationship_type_code = 'COMPONENT-OF'
4968: AND sysdate between nvl(active_start_date, sysdate-1)
4969: and nvl(active_end_date, sysdate+1);

Line 5094: csi_ii_relationships cir

5090: SELECT cir.subject_id,
5091: cir.relationship_id,
5092: cir.object_version_number
5093: FROM csi_item_instances cii_sub,
5094: csi_ii_relationships cir
5095: WHERE cir.object_id = p_top_config_instance_id
5096: AND cir.relationship_type_code = 'COMPONENT-OF'
5097: AND sysdate between nvl(cir.active_start_date, sysdate-1)
5098: and nvl(cir.active_end_date, sysdate+1)

Line 5505: p_pkg_name => 'csi_ii_relationships_pub',

5501: l_ii_rltns_qry_rec.object_id := l_config_instances(ci_ind).instance_id;
5502: l_ii_rltns_qry_rec.relationship_type_code := 'COMPONENT-OF';
5503:
5504: csi_t_gen_utility_pvt.dump_api_info(
5505: p_pkg_name => 'csi_ii_relationships_pub',
5506: p_api_name => 'get_relationships');
5507:
5508: csi_ii_relationships_pub.get_relationships(
5509: p_api_version => 1.0,

Line 5508: csi_ii_relationships_pub.get_relationships(

5504: csi_t_gen_utility_pvt.dump_api_info(
5505: p_pkg_name => 'csi_ii_relationships_pub',
5506: p_api_name => 'get_relationships');
5507:
5508: csi_ii_relationships_pub.get_relationships(
5509: p_api_version => 1.0,
5510: p_commit => fnd_api.g_false,
5511: p_init_msg_list => fnd_api.g_true,
5512: p_validation_level => fnd_api.g_valid_level_full,

Line 6556: p_pkg_name => 'csi_ii_relationships_pub',

6552:
6553: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
6554:
6555: csi_t_gen_utility_pvt.dump_api_info(
6556: p_pkg_name => 'csi_ii_relationships_pub',
6557: p_api_name => 'create_relationship');
6558:
6559: csi_ii_relationships_pub.create_relationship(
6560: p_api_version => 1.0,

Line 6559: csi_ii_relationships_pub.create_relationship(

6555: csi_t_gen_utility_pvt.dump_api_info(
6556: p_pkg_name => 'csi_ii_relationships_pub',
6557: p_api_name => 'create_relationship');
6558:
6559: csi_ii_relationships_pub.create_relationship(
6560: p_api_version => 1.0,
6561: p_commit => fnd_api.g_false,
6562: p_init_msg_list => fnd_api.g_true,
6563: p_validation_level => fnd_api.g_valid_level_full,

Line 6602: csi_ii_relationships cir

6598: SELECT cii.instance_id,
6599: cir.relationship_id,
6600: cir.object_version_number
6601: FROM csi_item_instances cii,
6602: csi_ii_relationships cir
6603: WHERE cir.object_id = p_config_instance_id
6604: AND cir.relationship_type_code = 'COMPONENT-OF'
6605: AND cii.instance_id = cir.subject_id
6606: AND cii.inventory_item_id = p_class_item_id;

Line 6704: p_pkg_name => 'csi_ii_relationships_pub',

6700: debug(' subject_id : '||l_ii_rltns_qry_rec.subject_id);
6701: debug(' relationship_type : '||l_ii_rltns_qry_rec.relationship_type_code);
6702:
6703: csi_t_gen_utility_pvt.dump_api_info(
6704: p_pkg_name => 'csi_ii_relationships_pub',
6705: p_api_name => 'get_relationships');
6706:
6707: csi_ii_relationships_pub.get_relationships(
6708: p_api_version => 1.0,

Line 6707: csi_ii_relationships_pub.get_relationships(

6703: csi_t_gen_utility_pvt.dump_api_info(
6704: p_pkg_name => 'csi_ii_relationships_pub',
6705: p_api_name => 'get_relationships');
6706:
6707: csi_ii_relationships_pub.get_relationships(
6708: p_api_version => 1.0,
6709: p_commit => fnd_api.g_false,
6710: p_init_msg_list => fnd_api.g_true,
6711: p_validation_level => fnd_api.g_valid_level_full,

Line 7049: p_pkg_name => 'csi_ii_relationships_pub',

7045:
7046: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7047:
7048: csi_t_gen_utility_pvt.dump_api_info(
7049: p_pkg_name => 'csi_ii_relationships_pub',
7050: p_api_name => 'create_relationship');
7051:
7052: csi_ii_relationships_pub.create_relationship(
7053: p_api_version => 1.0,

Line 7052: csi_ii_relationships_pub.create_relationship(

7048: csi_t_gen_utility_pvt.dump_api_info(
7049: p_pkg_name => 'csi_ii_relationships_pub',
7050: p_api_name => 'create_relationship');
7051:
7052: csi_ii_relationships_pub.create_relationship(
7053: p_api_version => 1.0,
7054: p_commit => fnd_api.g_false,
7055: p_init_msg_list => fnd_api.g_true,
7056: p_validation_level => fnd_api.g_valid_level_full,