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 249: FROM csi_item_instances

245: SELECT quantity,
246: inventory_item_id
247: INTO l_u_instance_rec.quantity,
248: l_u_instance_rec.inventory_item_id
249: FROM csi_item_instances
250: WHERE instance_id = l_u_instance_rec.instance_id;
251:
252:
253:

Line 757: FROM csi_item_instances

753: INTO l_u_instance_rec.object_version_number,
754: l_instance_usage_code ,
755: l_location_type_code,
756: l_quantity
757: FROM csi_item_instances
758: WHERE instance_id = l_u_instance_rec.instance_id;
759:
760: IF l_instance_usage_code = 'IN_RELATIONSHIP' THEN
761: SELECT object_id

Line 883: FROM csi_item_instances

879: SELECT location_type_code,
880: instance_usage_code
881: INTO l_instance_tbl(inst_ind).location_type_code,
882: l_instance_tbl(inst_ind).instance_usage_code
883: FROM csi_item_instances
884: WHERE instance_id = l_instance_tbl(inst_ind).instance_id;
885: END LOOP;
886: END IF;
887:

Line 923: FROM csi_item_instances

919: SELECT quantity,
920: object_version_number
921: INTO l_instance_quantity,
922: l_instance_ovn
923: FROM csi_item_instances
924: WHERE instance_id = p_instance_id;
925:
926: l_src_instance_rec.instance_id := p_instance_id;
927:

Line 1222: FROM csi_item_instances

1218: l_u_instance_rec.vld_organization_id := p_organization_id;
1219:
1220: SELECT object_version_number
1221: INTO l_u_instance_rec.object_version_number
1222: FROM csi_item_instances
1223: WHERE instance_id = l_u_instance_rec.instance_id;
1224:
1225: debug(' remain_qty(upd) : '||l_u_instance_rec.quantity);
1226: debug(' Inside API :csi_item_instance_pub.update_item_instance');

Line 1289: FROM csi_item_instances

1285: SELECT location_type_code,
1286: instance_usage_code
1287: INTO l_splitted_instances(x_ind).location_type_code,
1288: l_splitted_instances(x_ind).instance_usage_code
1289: FROM csi_item_instances
1290: WHERE instance_id = l_splitted_instances(x_ind).instance_id;
1291: END LOOP;
1292: END IF;
1293:

Line 2273: FROM csi_item_instances

2269: instance_id,
2270: serial_number,
2271: location_type_code,
2272: quantity
2273: FROM csi_item_instances
2274: WHERE inventory_item_id = p_parent_item_id
2275: AND last_oe_order_line_id = p_parent_line_id;
2276:
2277: l_parent_inst_found boolean := FALSE;

Line 2609: FROM csi_item_instances

2605: SELECT object_version_number,
2606: location_type_code
2607: INTO l_inst_object_ver_num,
2608: l_location_type_code
2609: FROM csi_item_instances
2610: WHERE instance_id = p_instance_id;
2611:
2612: l_order_header_rec := p_order_hdr_rec;
2613: l_order_line_rec := p_order_line_rec;

Line 2688: FROM csi_item_instances

2684: BEGIN
2685: IF NVL( p_instance_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2686: SELECT active_start_date
2687: INTO l_u_instance_rec.active_start_date
2688: FROM csi_item_instances
2689: WHERE instance_id = p_instance_id;
2690: ELSE
2691: l_u_instance_rec.active_start_date := nvl(l_tld_tbl(l_index).active_start_date,fnd_api.g_miss_date);
2692: END IF;

Line 2921: FROM csi_item_instances

2917: quantity,
2918: serial_number,
2919: location_type_code,
2920: instance_usage_code
2921: FROM csi_item_instances
2922: WHERE inventory_item_id = p_inventory_item_id
2923: AND ((location_type_code = 'WIP' AND wip_job_id = p_wip_entity_id)
2924: OR
2925: (instance_usage_code = 'IN_RELATIONSHIP' AND last_wip_job_id = p_wip_entity_id

Line 2939: FROM csi_item_instances

2935: quantity,
2936: serial_number,
2937: location_type_code,
2938: instance_usage_code
2939: FROM csi_item_instances
2940: WHERE inventory_item_id = p_inventory_item_id
2941: AND ((location_type_code = 'WIP' AND wip_job_id = p_wip_entity_id)
2942: OR
2943: (instance_usage_code = 'IN_RELATIONSHIP' AND last_wip_job_id = p_wip_entity_id

Line 3194: FROM csi_item_instances

3190: l_ind binary_integer := 0;
3191: px_ind binary_integer := 0;
3192: CURSOR inst_cur IS
3193: SELECT instance_id
3194: FROM csi_item_instances
3195: WHERE inventory_item_id = p_inventory_item_id
3196: AND last_oe_order_line_id = p_split_from_line_id;
3197: BEGIN
3198: IF px_wip_instances.COUNT > 0 THEN

Line 3677: FROM csi_item_instances

3673: p_item_id in number)
3674: IS
3675: SELECT instance_id,
3676: serial_number
3677: FROM csi_item_instances
3678: WHERE inventory_item_id = p_item_id
3679: AND last_oe_order_line_id = p_line_id;
3680:
3681: l_make_or_buy_flag varchar2(1) := 'B';

Line 4002: FROM csi_item_instances

3998: IS
3999: CURSOR config_inst_cur IS
4000: SELECT instance_id,
4001: location_type_code
4002: FROM csi_item_instances
4003: WHERE inventory_item_id = p_config_rec.item_id
4004: AND last_oe_order_line_id = p_config_rec.line_id;
4005:
4006: l_c_ind binary_integer := 0;

Line 4053: FROM csi_item_instances

4049: CURSOR inst_cur IS
4050: SELECT instance_id,
4051: serial_number,
4052: location_type_code
4053: FROM csi_item_instances
4054: WHERE inventory_item_id = p_config_rec.item_id
4055: AND last_oe_order_line_id = p_config_rec.line_id;
4056:
4057: l_config_inst_found boolean := FALSE;

Line 4070: FROM csi_item_instances cii_obj,

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

Line 4072: csi_item_instances cii_sub

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

Line 4084: FROM csi_item_instances cii

4080: CURSOR nsrl_sc_inst_cur IS
4081: SELECT cii.instance_id,
4082: cii.serial_number,
4083: cii.location_type_code
4084: FROM csi_item_instances cii
4085: WHERE cii.inventory_item_id = p_config_rec.sub_config_item_id
4086: AND ((cii.location_type_code = 'WIP'
4087: AND
4088: cii.wip_job_id = p_config_rec.config_wip_job_id)

Line 4164: FROM csi_item_instances

4160: SELECT instance_id ,
4161: location_type_code
4162: INTO l_instance_id,
4163: l_location_type_code
4164: FROM csi_item_instances
4165: WHERE inventory_item_id = p_config_rec.item_id
4166: AND serial_number = l_serial_number;
4167:
4168: l_c_ind := l_c_ind + 1;

Line 4193: FROM csi_item_instances

4189: SELECT instance_id,
4190: location_type_code
4191: INTO l_instance_id,
4192: l_location_type_code
4193: FROM csi_item_instances
4194: WHERE inventory_item_id = p_config_rec.item_id
4195: AND serial_number = l_serial_number;
4196:
4197: l_c_ind := l_c_ind + 1;

Line 4318: FROM csi_item_instances_h cih,

4314: IS
4315:
4316: CURSOR txn_cur(p_instance_id in number) IS
4317: SELECT ct.transaction_type_id
4318: FROM csi_item_instances_h cih,
4319: csi_transactions ct
4320: WHERE cih.instance_id = p_instance_id
4321: AND ct.transaction_id = cih.transaction_id
4322: AND NOT (ct.transaction_type_id = 51 AND ct.source_header_ref_id = p_header_id)

Line 4427: FROM csi_item_instances cii,

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

Line 4482: FROM csi_item_instances

4478:
4479: -- check if the instance is in WIP
4480: SELECT object_version_number
4481: INTO l_inst_object_ver_num
4482: FROM csi_item_instances
4483: WHERE instance_id = p_instance_id;
4484:
4485: l_u_instance_rec.instance_id := p_instance_id ;
4486: l_u_instance_rec.last_oe_order_line_id := p_order_line_id;

Line 4825: FROM csi_item_instances

4821: SELECT quantity ,
4822: last_vld_organization_id
4823: INTO l_instance_quantity ,
4824: l_vld_organization_id
4825: FROM csi_item_instances
4826: WHERE instance_id = px_ii_rltns_tbl(px_ind).subject_id;
4827:
4828: IF l_instance_quantity > p_quantity_ratio THEN
4829:

Line 4947: FROM csi_item_instances cii

4943: l_wip_instances wip_instances;
4944: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4945: CURSOR option_cp_cur IS
4946: SELECT cii.instance_id
4947: FROM csi_item_instances cii
4948: WHERE cii.inventory_item_id = p_option_line_rec.inventory_item_id
4949: AND cii.last_oe_order_line_id = p_option_line_rec.line_id
4950: AND cii.location_type_code = 'HZ_PARTY_SITES'
4951: AND cii.instance_usage_code IN ( 'OUT_OF_ENTERPRISE','IN_RELATIONSHIP') -- Changed for bug#14267193

Line 4967: FROM csi_item_instances cii

4963: FOR px_ind IN px_ii_rltns_tbl.FIRST .. px_ii_rltns_tbl.LAST
4964: LOOP
4965: BEGIN
4966: SELECT 'Y' INTO l_option_instance
4967: FROM csi_item_instances cii
4968: WHERE cii.instance_id = px_ii_rltns_tbl(px_ind).subject_id
4969: AND cii.inventory_item_id = p_option_line_rec.inventory_item_id;
4970:
4971: l_ind := l_ind + 1;

Line 5062: FROM csi_item_instances

5058: --If the child phantom option item has an item instance, then it would have already interfaced to IB
5059: --So, we need to break its relationship with the config item instance and bring in the option class in between
5060: BEGIN
5061: SELECT 'Y' INTO l_phantom
5062: FROM csi_item_instances
5063: WHERE inventory_item_id = p_option_item_id
5064: AND last_oe_order_line_id = NVL(p_line_id,-1);
5065: debug(' supply_type : phantom - Instance exists, WIP processing = true' );
5066: l_wip_processing := TRUE;

Line 5108: FROM csi_item_instances

5104: END;
5105: IF(nvl(l_shippable_item_flag, 'N') <> 'Y') THEN
5106: BEGIN
5107: SELECT 'Y' INTO l_phantom
5108: FROM csi_item_instances
5109: WHERE inventory_item_id = p_option_item_id
5110: AND last_oe_order_line_id = NVL(p_line_id,-1);
5111: debug(' Non Shippable: wip requirements deleted/altered/substituted - Instance exists, WIP processing = true' );
5112: l_wip_processing := TRUE;

Line 5484: FROM csi_item_instances cii_sub,

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

Line 5532: FROM csi_item_instances

5528: LOOP
5529: BEGIN
5530: SELECT instance_id
5531: INTO x_config_instance.instance_id
5532: FROM csi_item_instances
5533: WHERE instance_id = l_iir_tbl(iir_ind).object_id
5534: AND inventory_item_id = p_config_rec.item_id;
5535: exit;
5536: EXCEPTION

Line 5871: FROM csi_item_instances CII

5867: AND p_order_line_rec.ato_line_id <> l_parent_line_rec.line_id THEN
5868: BEGIN
5869: SELECT CII.instance_id
5870: INTO l_parent_inst_id
5871: FROM csi_item_instances CII
5872: WHERE CII.last_oe_order_line_id = l_parent_line_rec.line_id;
5873: EXCEPTION
5874: WHEN OTHERS THEN
5875: l_parent_inst_id := l_config_instances(ci_ind).instance_id;

Line 7371: FROM csi_item_instances cii,

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

Line 7459: FROM csi_item_instances

7455: CURSOR inst_cur(p_instance_id IN number) IS
7456: SELECT instance_id,
7457: serial_number,
7458: location_type_code
7459: FROM csi_item_instances
7460: WHERE instance_id = p_instance_id
7461: AND inventory_item_id = p_config_rec.item_id;
7462:
7463: BEGIN

Line 8111: l_inst_loc_type csi_item_instances.location_type_code%TYPE;

8107: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8108: l_msg_data varchar2(2000);
8109: l_msg_count number;
8110: l_inst_loc_id number;
8111: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
8112: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
8113: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
8114: l_quantity1 NUMBER;
8115: l_vld_orgn_id number;

Line 9561: from CSI_ITEM_INSTANCES

9557: --
9558: IF l_ul_instance_rec.instance_id IS NOT NULL THEN
9559: select object_version_number
9560: into l_ul_instance_rec.object_version_number
9561: from CSI_ITEM_INSTANCES
9562: where instance_id = l_ul_instance_rec.instance_id;
9563: --
9564: l_ul_instance_rec.last_oe_order_line_id := p_order_line_id;
9565: --

Line 11346: FROM csi_item_instances

11342: INTO l_exp_instance_id,
11343: l_exp_obj_ver_num,
11344: l_exp_active_end_date,
11345: l_exp_loc_type_code
11346: FROM csi_item_instances
11347: WHERE inventory_item_id = mmt_rec.inventory_item_id
11348: AND serial_number = mmt_rec.serial_number;
11349: EXCEPTION
11350: WHEN no_data_found THEN

Line 11425: FROM csi_item_instances

11421:
11422: BEGIN
11423: SELECT object_version_number
11424: INTO l_exp_instance_rec.object_version_number
11425: FROM csi_item_instances
11426: WHERE instance_id = l_exp_instance_id;
11427: END;
11428:
11429: x_order_shipment_tbl(l_count).instance_id := l_exp_instance_id;