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_SHIP_PUB dependencies on CSI_ITEM_INSTANCES

Line 1467: FROM csi_item_instances

1463: INTO l_ns_instance_rec.object_version_number,
1464: l_location_code,
1465: l_serial_number,
1466: l_active_end_date
1467: FROM csi_item_instances
1468: WHERE instance_id = p_txn_line_detail_rec.instance_id;
1469:
1470: debug(' TXN Line Dtl ID :'||p_txn_line_detail_rec.txn_line_detail_id);
1471: debug(' Instance ID :'||l_ns_instance_rec.instance_id );

Line 1553: FROM csi_item_instances

1549: -- expiring the instance back. Added this IF for Bug 3039821
1550:
1551: SELECT object_version_number
1552: INTO l_exp_instance_rec.object_version_number
1553: FROM csi_item_instances
1554: WHERE instance_id = p_txn_line_detail_rec.instance_id;
1555:
1556: l_exp_instance_rec.instance_id := p_txn_line_detail_rec.instance_id;
1557:

Line 2158: From csi_item_instances

2154:
2155: -- debug('After Create OBJECT_VERSION_NUMBER '||l_cre_instance_rec.object_version_number);
2156: Select object_version_number
2157: Into l_zero_instance_rec.object_version_number
2158: From csi_item_instances
2159: Where instance_id = l_cre_instance_rec.instance_id;
2160:
2161: -- debug('Before calling update OBJECT_VERSION_NUMBER '||l_zero_instance_rec.object_version_number);
2162:

Line 2200: From csi_item_instances

2196: -- l_instance_header_tbl(1).object_version_number := l_cre_instance_rec.object_version_number;
2197:
2198: Select object_version_number
2199: Into l_instance_header_tbl(1).object_version_number
2200: From csi_item_instances
2201: Where instance_id = l_zero_instance_rec.instance_id;
2202:
2203: px_error_rec.instance_id := l_zero_instance_rec.instance_id;
2204:

Line 2814: FROM csi_item_instances

2810:
2811: BEGIN
2812: SELECT instance_usage_code
2813: INTO l_instance_usage_code
2814: FROM csi_item_instances
2815: WHERE instance_id = px_txn_line_detail_tbl(l_ind).instance_id;
2816: EXCEPTION
2817: WHEN no_data_found THEN
2818: l_instance_usage_code := 'NULL';

Line 3761: FROM csi_item_instances

3757: SELECT object_version_number,
3758: quantity - p_quantity
3759: INTO l_instance_rec.object_version_number,
3760: l_instance_rec.quantity
3761: FROM csi_item_instances
3762: WHERE instance_id = l_instance_rec.instance_id;
3763:
3764: csi_t_gen_utility_pvt.dump_api_info(
3765: p_api_name => 'update_item_instance',

Line 4079: FROM csi_item_instances

4075: l_u_instance_rec.vld_organization_id := p_organization_id;
4076:
4077: SELECT object_version_number
4078: INTO l_u_instance_rec.object_version_number
4079: FROM csi_item_instances
4080: WHERE instance_id = l_u_instance_rec.instance_id;
4081:
4082: csi_item_instance_pub.update_item_instance(
4083: p_api_version => 1.0,

Line 4187: FROM csi_item_instances

4183: SELECT object_version_number,
4184: location_type_code
4185: INTO l_inst_object_ver_num,
4186: l_location_type_code
4187: FROM csi_item_instances
4188: WHERE instance_id = p_instance_id;
4189:
4190: SELECT * INTO l_order_line_rec
4191: FROM oe_order_lines_all

Line 4375: FROM csi_item_instances

4371: CURSOR wip_nsrl_cur(p_item_id IN number) IS
4372: SELECT instance_id,
4373: quantity,
4374: serial_number
4375: FROM csi_item_instances
4376: WHERE inventory_item_id = p_item_id
4377: AND location_type_code = 'WIP'
4378: AND wip_job_id = p_wip_entity_id;
4379:

Line 4384: FROM csi_item_instances

4380: CURSOR wip_inst_cur(p_item_id IN number, p_qty_per_assy IN number) IS
4381: SELECT instance_id,
4382: quantity,
4383: serial_number
4384: FROM csi_item_instances
4385: WHERE inventory_item_id = p_item_id
4386: AND location_type_code = 'WIP'
4387: AND wip_job_id = p_wip_entity_id
4388: AND quantity <= p_qty_per_assy;

Line 4734: FROM csi_item_instances

4730:
4731: BEGIN
4732: SELECT sum(quantity)
4733: INTO l_total_qty
4734: FROM csi_item_instances
4735: WHERE last_oe_order_line_id = p_order_line_rec.order_line_id
4736: AND inventory_item_id = p_order_line_rec.inv_item_id;
4737: EXCEPTION
4738: WHEN others then

Line 5451: FROM csi_item_instances

5447: object_version_number
5448: INTO l_so_instance_id,
5449: l_so_qty,
5450: l_so_obj_ver_num
5451: FROM csi_item_instances
5452: WHERE serial_number = l_tld_rec.serial_number
5453: AND inventory_item_id = l_tld_rec.inventory_item_id
5454: AND (instance_usage_code = 'RETURNED' --added the outer braces for bug6310708
5455: --Start of code for 6188180

Line 5533: FROM csi_item_instances

5529: l_instance_id := l_tld_rec.changed_instance_id;
5530:
5531: SELECT object_version_number
5532: INTO l_inst_obj_ver_num
5533: FROM csi_item_instances
5534: WHERE instance_id = l_tld_rec.changed_instance_id;
5535:
5536: csi_utl_pkg.rebuild_tbls(
5537: p_new_instance_id => l_instance_id,

Line 5900: FROM CSI_ITEM_INSTANCES

5896: SELECT owner_party_id,
5897: object_version_number
5898: INTO l_owner_party_id,
5899: l_chg_instance_rec.object_version_number
5900: FROM CSI_ITEM_INSTANCES
5901: WHERE instance_id = l_upd_party_tbl(1).instance_id;
5902:
5903: IF l_owner_party_id <> p_order_line_rec.internal_party_id
5904: AND

Line 5965: FROM CSI_ITEM_INSTANCES

5961: /* Fixed for Bug 2728984 */
5962: BEGIN
5963: SELECT object_version_number
5964: INTO l_upd_instance_rec.object_version_number
5965: FROM CSI_ITEM_INSTANCES
5966: WHERE instance_id = l_upd_instance_rec.instance_id;
5967: END;
5968:
5969: BEGIN

Line 8590: FROM csi_item_instances

8586: LOOP
8587: BEGIN
8588: SELECT instance_id
8589: INTO l_mtl_txn_tbl(ret_ind).instance_id
8590: FROM csi_item_instances
8591: WHERE inventory_item_id = l_mtl_txn_tbl(ret_ind).inventory_item_id
8592: AND serial_number = l_mtl_txn_tbl(ret_ind).serial_number
8593: AND instance_usage_code = 'RETURNED';
8594: EXCEPTION