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_ITEM_INSTANCES

Line 226: FROM csi_item_instances

222: SELECT quantity,
223: inventory_item_id
224: INTO l_u_instance_rec.quantity,
225: l_u_instance_rec.inventory_item_id
226: FROM csi_item_instances
227: WHERE instance_id = l_u_instance_rec.instance_id;
228:
229:
230:

Line 717: FROM csi_item_instances

713: INTO l_u_instance_rec.object_version_number,
714: l_instance_usage_code ,
715: l_location_type_code,
716: l_quantity
717: FROM csi_item_instances
718: WHERE instance_id = l_u_instance_rec.instance_id;
719:
720: IF l_instance_usage_code = 'IN_RELATIONSHIP' THEN
721: SELECT object_id

Line 843: FROM csi_item_instances

839: SELECT location_type_code,
840: instance_usage_code
841: INTO l_instance_tbl(inst_ind).location_type_code,
842: l_instance_tbl(inst_ind).instance_usage_code
843: FROM csi_item_instances
844: WHERE instance_id = l_instance_tbl(inst_ind).instance_id;
845: END LOOP;
846: END IF;
847:

Line 883: FROM csi_item_instances

879: SELECT quantity,
880: object_version_number
881: INTO l_instance_quantity,
882: l_instance_ovn
883: FROM csi_item_instances
884: WHERE instance_id = p_instance_id;
885:
886: l_src_instance_rec.instance_id := p_instance_id;
887:

Line 1182: FROM csi_item_instances

1178: l_u_instance_rec.vld_organization_id := p_organization_id;
1179:
1180: SELECT object_version_number
1181: INTO l_u_instance_rec.object_version_number
1182: FROM csi_item_instances
1183: WHERE instance_id = l_u_instance_rec.instance_id;
1184:
1185: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1186: debug(' Inside API :csi_item_instance_pub.update_item_instance');

Line 1249: FROM csi_item_instances

1245: SELECT location_type_code,
1246: instance_usage_code
1247: INTO l_splitted_instances(x_ind).location_type_code,
1248: l_splitted_instances(x_ind).instance_usage_code
1249: FROM csi_item_instances
1250: WHERE instance_id = l_splitted_instances(x_ind).instance_id;
1251: END LOOP;
1252: END IF;
1253:

Line 2233: FROM csi_item_instances

2229: instance_id,
2230: serial_number,
2231: location_type_code,
2232: quantity
2233: FROM csi_item_instances
2234: WHERE inventory_item_id = p_parent_item_id
2235: AND last_oe_order_line_id = p_parent_line_id;
2236:
2237: l_parent_inst_found boolean := FALSE;

Line 2569: FROM csi_item_instances

2565: SELECT object_version_number,
2566: location_type_code
2567: INTO l_inst_object_ver_num,
2568: l_location_type_code
2569: FROM csi_item_instances
2570: WHERE instance_id = p_instance_id;
2571:
2572: l_order_header_rec := p_order_hdr_rec;
2573: l_order_line_rec := p_order_line_rec;

Line 2648: FROM csi_item_instances

2644: BEGIN
2645: IF NVL( p_instance_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2646: SELECT active_start_date
2647: INTO l_u_instance_rec.active_start_date
2648: FROM csi_item_instances
2649: WHERE instance_id = p_instance_id;
2650: ELSE
2651: l_u_instance_rec.active_start_date := nvl(l_tld_tbl(l_index).active_start_date,fnd_api.g_miss_date);
2652: END IF;

Line 2881: FROM csi_item_instances

2877: quantity,
2878: serial_number,
2879: location_type_code,
2880: instance_usage_code
2881: FROM csi_item_instances
2882: WHERE inventory_item_id = p_inventory_item_id
2883: AND ((location_type_code = 'WIP' AND wip_job_id = p_wip_entity_id)
2884: OR
2885: (instance_usage_code = 'IN_RELATIONSHIP' AND last_wip_job_id = p_wip_entity_id));

Line 2896: FROM csi_item_instances

2892: quantity,
2893: serial_number,
2894: location_type_code,
2895: instance_usage_code
2896: FROM csi_item_instances
2897: WHERE inventory_item_id = p_inventory_item_id
2898: AND ((location_type_code = 'WIP' AND wip_job_id = p_wip_entity_id)
2899: OR
2900: (instance_usage_code = 'IN_RELATIONSHIP' AND last_wip_job_id = p_wip_entity_id));

Line 3148: FROM csi_item_instances

3144: l_ind binary_integer := 0;
3145: px_ind binary_integer := 0;
3146: CURSOR inst_cur IS
3147: SELECT instance_id
3148: FROM csi_item_instances
3149: WHERE inventory_item_id = p_inventory_item_id
3150: AND last_oe_order_line_id = p_split_from_line_id;
3151: BEGIN
3152: IF px_wip_instances.COUNT > 0 THEN

Line 3629: FROM csi_item_instances

3625: p_item_id in number)
3626: IS
3627: SELECT instance_id,
3628: serial_number
3629: FROM csi_item_instances
3630: WHERE inventory_item_id = p_item_id
3631: AND last_oe_order_line_id = p_line_id;
3632:
3633: l_make_or_buy_flag varchar2(1) := 'B';

Line 3954: FROM csi_item_instances

3950: IS
3951: CURSOR config_inst_cur IS
3952: SELECT instance_id,
3953: location_type_code
3954: FROM csi_item_instances
3955: WHERE inventory_item_id = p_config_rec.item_id
3956: AND last_oe_order_line_id = p_config_rec.line_id;
3957:
3958: l_c_ind binary_integer := 0;

Line 4005: FROM csi_item_instances

4001: CURSOR inst_cur IS
4002: SELECT instance_id,
4003: serial_number,
4004: location_type_code
4005: FROM csi_item_instances
4006: WHERE inventory_item_id = p_config_rec.item_id
4007: AND last_oe_order_line_id = p_config_rec.line_id;
4008:
4009: l_config_inst_found boolean := FALSE;

Line 4022: FROM csi_item_instances cii_obj,

4018: CURSOR in_rel_sc_inst_cur IS
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

Line 4024: csi_item_instances cii_sub

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
4028: AND cir.relationship_type_code = 'COMPONENT-OF'

Line 4036: FROM csi_item_instances cii

4032: CURSOR nsrl_sc_inst_cur IS
4033: SELECT cii.instance_id,
4034: cii.serial_number,
4035: cii.location_type_code
4036: FROM csi_item_instances cii
4037: WHERE cii.inventory_item_id = p_config_rec.sub_config_item_id
4038: AND ((cii.location_type_code = 'WIP'
4039: AND
4040: cii.wip_job_id = p_config_rec.config_wip_job_id)

Line 4116: FROM csi_item_instances

4112: SELECT instance_id ,
4113: location_type_code
4114: INTO l_instance_id,
4115: l_location_type_code
4116: FROM csi_item_instances
4117: WHERE inventory_item_id = p_config_rec.item_id
4118: AND serial_number = l_serial_number;
4119:
4120: l_c_ind := l_c_ind + 1;

Line 4145: FROM csi_item_instances

4141: SELECT instance_id,
4142: location_type_code
4143: INTO l_instance_id,
4144: l_location_type_code
4145: FROM csi_item_instances
4146: WHERE inventory_item_id = p_config_rec.item_id
4147: AND serial_number = l_serial_number;
4148:
4149: l_c_ind := l_c_ind + 1;

Line 4270: FROM csi_item_instances_h cih,

4266: IS
4267:
4268: CURSOR txn_cur(p_instance_id in number) IS
4269: SELECT ct.transaction_type_id
4270: FROM csi_item_instances_h cih,
4271: csi_transactions ct
4272: WHERE cih.instance_id = p_instance_id
4273: AND ct.transaction_id = cih.transaction_id
4274: AND NOT (ct.transaction_type_id = 51 AND ct.source_header_ref_id = p_header_id)

Line 4379: FROM csi_item_instances cii,

4375: l_option_instances csi_datastructures_pub.instance_tbl;
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

Line 4434: FROM csi_item_instances

4430:
4431: -- check if the instance is in WIP
4432: SELECT object_version_number
4433: INTO l_inst_object_ver_num
4434: FROM csi_item_instances
4435: WHERE instance_id = p_instance_id;
4436:
4437: l_u_instance_rec.instance_id := p_instance_id ;
4438: l_u_instance_rec.last_oe_order_line_id := p_order_line_id;

Line 4777: FROM csi_item_instances

4773: SELECT quantity ,
4774: last_vld_organization_id
4775: INTO l_instance_quantity ,
4776: l_vld_organization_id
4777: FROM csi_item_instances
4778: WHERE instance_id = px_ii_rltns_tbl(px_ind).subject_id;
4779:
4780: IF l_instance_quantity > p_quantity_ratio THEN
4781:

Line 4899: FROM csi_item_instances cii

4895: l_wip_instances wip_instances;
4896: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4897: CURSOR option_cp_cur IS
4898: SELECT cii.instance_id
4899: FROM csi_item_instances cii
4900: WHERE cii.inventory_item_id = p_option_line_rec.inventory_item_id
4901: AND cii.last_oe_order_line_id = p_option_line_rec.line_id
4902: AND cii.location_type_code = 'HZ_PARTY_SITES'
4903: AND cii.instance_usage_code = 'OUT_OF_ENTERPRISE'

Line 4919: FROM csi_item_instances cii

4915: FOR px_ind IN px_ii_rltns_tbl.FIRST .. px_ii_rltns_tbl.LAST
4916: LOOP
4917: BEGIN
4918: SELECT 'Y' INTO l_option_instance
4919: FROM csi_item_instances cii
4920: WHERE cii.instance_id = px_ii_rltns_tbl(px_ind).subject_id
4921: AND cii.inventory_item_id = p_option_line_rec.inventory_item_id;
4922:
4923: l_ind := l_ind + 1;

Line 5093: FROM csi_item_instances cii_sub,

5089: IS
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)

Line 5141: FROM csi_item_instances

5137: LOOP
5138: BEGIN
5139: SELECT instance_id
5140: INTO x_config_instance.instance_id
5141: FROM csi_item_instances
5142: WHERE instance_id = l_iir_tbl(iir_ind).object_id
5143: AND inventory_item_id = p_config_rec.item_id;
5144: exit;
5145: EXCEPTION

Line 6601: FROM csi_item_instances cii,

6597: CURSOR class_inst_cur IS
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

Line 6689: FROM csi_item_instances

6685: CURSOR inst_cur(p_instance_id IN number) IS
6686: SELECT instance_id,
6687: serial_number,
6688: location_type_code
6689: FROM csi_item_instances
6690: WHERE instance_id = p_instance_id
6691: AND inventory_item_id = p_config_rec.item_id;
6692:
6693: BEGIN

Line 7314: l_inst_loc_type csi_item_instances.location_type_code%TYPE;

7310: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7311: l_msg_data varchar2(2000);
7312: l_msg_count number;
7313: l_inst_loc_id number;
7314: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
7315: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
7316: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
7317: l_quantity1 NUMBER;
7318: l_vld_orgn_id number;

Line 8606: from CSI_ITEM_INSTANCES

8602: --
8603: IF l_ul_instance_rec.instance_id IS NOT NULL THEN
8604: select object_version_number
8605: into l_ul_instance_rec.object_version_number
8606: from CSI_ITEM_INSTANCES
8607: where instance_id = l_ul_instance_rec.instance_id;
8608: --
8609: l_ul_instance_rec.last_oe_order_line_id := p_order_line_id;
8610: --

Line 10330: FROM csi_item_instances

10326: INTO l_exp_instance_id,
10327: l_exp_obj_ver_num,
10328: l_exp_active_end_date,
10329: l_exp_loc_type_code
10330: FROM csi_item_instances
10331: WHERE inventory_item_id = mmt_rec.inventory_item_id
10332: AND serial_number = mmt_rec.serial_number;
10333: EXCEPTION
10334: WHEN no_data_found THEN

Line 10409: FROM csi_item_instances

10405:
10406: BEGIN
10407: SELECT object_version_number
10408: INTO l_exp_instance_rec.object_version_number
10409: FROM csi_item_instances
10410: WHERE instance_id = l_exp_instance_id;
10411: END;
10412:
10413: x_order_shipment_tbl(l_count).instance_id := l_exp_instance_id;