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

Line 467: FROM csi_item_instances

463: SELECT quantity + p_quantity,
464: object_version_number
465: INTO l_u_instance_rec.quantity,
466: l_u_instance_rec.object_version_number
467: FROM csi_item_instances
468: WHERE instance_id = p_instance_id;
469:
470: api_log(
471: p_pkg_name => 'csi_item_instance_pub',

Line 540: FROM csi_item_instances

536: SELECT quantity - p_quantity,
537: object_version_number
538: INTO l_u_instance_rec.quantity,
539: l_u_instance_rec.object_version_number
540: FROM csi_item_instances
541: WHERE instance_id = l_u_instance_rec.instance_id;
542:
543: api_log(
544: p_pkg_name => 'csi_item_instance_pub',

Line 1641: FROM csi_item_instances

1637: l_u_instance_rec.vld_organization_id := p_organization_id;
1638:
1639: SELECT object_version_number
1640: INTO l_u_instance_rec.object_version_number
1641: FROM csi_item_instances
1642: WHERE instance_id = l_u_instance_rec.instance_id;
1643:
1644: api_log(
1645: p_pkg_name => 'csi_item_instance_pub',

Line 1981: FROM csi_item_instances

1977: l_u_instance_rec.vld_organization_id := p_organization_id;
1978:
1979: SELECT object_version_number
1980: INTO l_u_instance_rec.object_version_number
1981: FROM csi_item_instances
1982: WHERE instance_id = l_u_instance_rec.instance_id;
1983:
1984: api_log(
1985: p_pkg_name => 'csi_item_instance_pub',

Line 2180: FROM csi_item_instances

2176: BEGIN
2177:
2178: SELECT instance_id
2179: INTO l_child_instance_id
2180: FROM csi_item_instances
2181: WHERE inventory_item_id = mog_rec.child_item_id
2182: AND serial_number = mog_rec.child_serial_number;
2183:
2184: debug(' Instance ID :'||l_child_instance_id);

Line 2307: csi_item_instances cii

2303: BEGIN
2304: SELECT count(*)
2305: INTO l_alloc_count
2306: FROM csi_ii_relationships cir,
2307: csi_item_instances cii
2308: WHERE cir.object_id = p_object_id
2309: AND cir.relationship_type_code = 'COMPONENT-OF'
2310: AND sysdate BETWEEN nvl(cir.active_start_date, sysdate-1)
2311: AND nvl(cir.active_end_date, sysdate+1)

Line 2490: csi_item_instances cii

2486:
2487: CURSOR comp_cur (p_object_id in number, p_comp_item_id in number) IS
2488: SELECT cir.subject_id, cii.quantity
2489: FROM csi_ii_relationships cir,
2490: csi_item_instances cii
2491: WHERE cir.object_id = p_object_id
2492: AND cir.relationship_type_code = 'COMPONENT-OF'
2493: AND cii.instance_id = cir.subject_id
2494: AND cii.inventory_item_id = p_comp_item_id

Line 2539: csi_item_instances cii

2535: BEGIN
2536: SELECT sum(cii.quantity)
2537: INTO l_alloc_qty
2538: FROM csi_ii_relationships cir,
2539: csi_item_instances cii
2540: WHERE cir.object_id = p_object_id
2541: AND cir.relationship_type_code = 'COMPONENT-OF'
2542: AND cii.instance_id = cir.subject_id
2543: AND cii.inventory_item_id = p_comp_item_id;

Line 2983: csi_item_instances cii

2979:
2980: CURSOR rltns_cur(p_parent_instance_id IN number) IS
2981: SELECT cir.subject_id, cii.quantity
2982: FROM csi_ii_relationships cir,
2983: csi_item_instances cii
2984: WHERE cir.object_id = p_parent_instance_id
2985: AND cir.relationship_type_code = 'COMPONENT-OF'
2986: AND cii.instance_id = cir.subject_id
2987: AND cii.inventory_item_id = p_component_item_id

Line 3083: FROM csi_item_instances

3079:
3080: BEGIN
3081: SELECT instance_id
3082: INTO l_parent_instance_id
3083: FROM csi_item_instances
3084: WHERE inventory_item_id = l_parent_item_id
3085: AND serial_number = l_parent_serial_number
3086: AND nvl(active_end_date,sysdate+1) > sysdate; --fix for bug 5393515
3087:

Line 4813: -- look for a serialized instance in csi_item_instances

4809:
4810: x_return_status := fnd_api.g_ret_sts_success;
4811: api_log('get_issued_serial_instance');
4812:
4813: -- look for a serialized instance in csi_item_instances
4814: -- if it is in customer location then
4815:
4816: l_inst_query_rec.inventory_item_id := px_instance_rec.inventory_item_id;
4817: l_inst_query_rec.serial_number := px_instance_rec.serial_number;

Line 5503: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir

5499:
5500: BEGIN
5501: select cir.subject_id,ci2.quantity
5502: into l_instance_id, l_quantity
5503: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir
5504: where ci1.instance_id = cir.object_id
5505: and ci1.inventory_item_id = l_inv_item_id
5506: and ci1.serial_number = l_serial_number
5507: and ci2.inventory_item_id = p_mmt_rec.inventory_item_id

Line 5837: FROM csi_item_instances

5833: INTO l_comp_is_assy
5834: FROM sys.dual
5835: WHERE exists (
5836: SELECT 'X'
5837: FROM csi_item_instances
5838: WHERE last_vld_organization_id = p_mmt_rec.organization_id
5839: AND location_type_code = 'WIP'
5840: AND wip_job_id = p_mmt_rec.transaction_source_id
5841: AND serial_number = p_mmt_rec.serial_number

Line 6420: FROM csi_item_instances

6416: SELECT quantity,
6417: last_vld_organization_id
6418: INTO l_sub_instance_qty,
6419: l_vld_organization_id
6420: FROM csi_item_instances
6421: WHERE instance_id = l_sub_instance_id;
6422:
6423: IF l_sub_instance_qty > l_sub_tld_qty THEN
6424:

Line 6724: FROM csi_item_instances

6720: CURSOR wip_inst_cur(p_wip_entity_id IN number, p_instance_id IN number) IS
6721: SELECT instance_id,
6722: quantity,
6723: serial_number
6724: FROM csi_item_instances
6725: WHERE location_type_code = 'WIP'
6726: AND wip_job_id = p_wip_entity_id
6727: AND instance_id <> p_instance_id;
6728: