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.AHL_UC_INSTANCE_PVT dependencies on CSI_ITEM_INSTANCES

Line 10: FROM csi_item_instances

6:
7: -- Define global cursors
8: CURSOR get_instance_date(c_instance_id NUMBER) IS
9: SELECT active_end_date
10: FROM csi_item_instances
11: WHERE instance_id = c_instance_id;
12:
13: -- Local validation procedures
14: -- Procedure to validate serial numbers

Line 337: csi_item_instances c

333: /*
334: SELECT o.operating_unit
335: FROM org_organization_definitions o,
336: mtl_system_items_kfv m,
337: csi_item_instances c
338: WHERE c.instance_id = p_instance_id
339: AND c.inventory_item_id = m.inventory_item_id
340: AND c.inv_master_organization_id = m.organization_id
341: AND m.organization_id = o.organization_id;

Line 345: csi_item_instances c

341: AND m.organization_id = o.organization_id;
342: */
343: SELECT i.operating_unit
344: FROM inv_organization_info_v i, mtl_system_items_kfv m,
345: csi_item_instances c
346: WHERE c.instance_id = p_instance_id AND
347: c.inventory_item_id = m.inventory_item_id AND
348: c.inv_master_organization_id = m.organization_id AND
349: m.organization_id = i.organization_id;

Line 759: FROM csi_item_instances

755: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
756: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
757: CURSOR get_csi_obj_ver_num(c_instance_id NUMBER) IS
758: SELECT object_version_number
759: FROM csi_item_instances
760: WHERE instance_id = c_instance_id
761: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
762: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
763:

Line 1380: FROM csi_item_instances

1376: unit_of_measure,
1377: install_date,
1378: inventory_revision,
1379: object_version_number
1380: FROM csi_item_instances
1381: WHERE instance_id = c_instance_id;
1382: --Removed on 02/26/2004, otherwise for expired instance, the error message displayed makes no sense.
1383: --AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
1384: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2225: -- This API is used to create a new instance in csi_item_instances and assign it

2221: p_data => x_msg_data);
2222: END;
2223:
2224: -- Define procedure install_new_instance
2225: -- This API is used to create a new instance in csi_item_instances and assign it
2226: -- to a UC node.
2227: PROCEDURE install_new_instance(
2228: p_api_version IN NUMBER := 1.0,
2229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 2359: FROM csi_item_instances csi, csi_i_parties p

2355: party_id,
2356: party_source_table,
2357: instance_party_id,
2358: csi.wip_job_id
2359: FROM csi_item_instances csi, csi_i_parties p
2360: WHERE csi.instance_id = p.instance_id
2361: AND p.relationship_type_code = 'OWNER'
2362: AND csi.instance_id = c_csi_instance_id
2363: AND trunc(SYSDATE) < trunc(nvl(csi.active_end_date, SYSDATE+1));

Line 2402: FROM csi_item_instances c,

2398: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2399:
2400: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
2401: SELECT i.interchange_type_code
2402: FROM csi_item_instances c,
2403: ahl_item_associations_b i,
2404: ahl_mc_relationships m
2405: WHERE m.relationship_id = c_relationship_id
2406: AND c.instance_id = c_instance_id

Line 3303: p_instance_number IN csi_item_instances.instance_number%TYPE := NULL,

3299: x_msg_data OUT NOCOPY VARCHAR2,
3300: p_uc_header_id IN NUMBER,
3301: p_parent_instance_id IN NUMBER,
3302: p_instance_id IN NUMBER,
3303: p_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
3304: p_relationship_id IN NUMBER,
3305: p_csi_ii_ovn IN NUMBER,
3306: p_prod_user_flag IN VARCHAR2,
3307: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type)

Line 3357: l_serial_number csi_item_instances.serial_number%TYPE;

3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3359: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3360:
3361: l_return_val BOOLEAN;

Line 3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;

3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3359: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3360:
3361: l_return_val BOOLEAN;
3362: l_transaction_type_id NUMBER;

Line 3523: FROM csi_item_instances C,

3519: C.instance_usage_code,
3520: C.location_type_code,
3521: C.object_version_number,
3522: U.unit_config_header_id uc_header_id
3523: FROM csi_item_instances C,
3524: ahl_unit_config_headers U
3525: WHERE C.instance_id = c_instance_id
3526: AND C.instance_id = U.csi_item_instance_id (+)
3527: --AND U.parent_uc_header_id (+) IS NULL

Line 3575: FROM csi_item_instances

3571: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3572:
3573: CURSOR get_serial_number(c_instance_id NUMBER) IS
3574: SELECT serial_number, mfg_serial_number_flag
3575: FROM csi_item_instances
3576: WHERE instance_id = c_instance_id
3577: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
3578: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3579:

Line 3593: FROM csi_item_instances c,

3589: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3590:
3591: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
3592: SELECT i.interchange_type_code
3593: FROM csi_item_instances c,
3594: ahl_item_associations_b i,
3595: ahl_mc_relationships m
3596: WHERE m.relationship_id = c_relationship_id
3597: AND c.instance_id = c_instance_id

Line 4430: p_new_instance_number IN csi_item_instances.instance_number%TYPE := NULL,

4426: p_uc_header_id IN NUMBER,
4427: p_parent_instance_id IN NUMBER,
4428: p_old_instance_id IN NUMBER,
4429: p_new_instance_id IN NUMBER,
4430: p_new_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
4431: p_relationship_id IN NUMBER,
4432: p_csi_ii_ovn IN NUMBER,
4433: p_prod_user_flag IN VARCHAR2,
4434: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type)

Line 4647: FROM csi_item_instances C,

4643: C.unit_of_measure uom_code,
4644: C.inv_subinventory_name,
4645: C.inv_locator_id,
4646: to_number(NULL) uc_header_id
4647: FROM csi_item_instances C,
4648: mtl_system_items_kfv M,
4649: ahl_mc_relationships R,
4650: ahl_item_associations_b A
4651: WHERE C.inventory_item_id = M.inventory_item_id

Line 4762: csi_item_instances C,

4758: C.inv_subinventory_name,
4759: C.inv_locator_id,
4760: U.uc_header_id uc_header_id
4761: FROM ahl_unit_config_headers_v U,
4762: csi_item_instances C,
4763: mtl_system_items_kfv M
4764: WHERE U.csi_instance_id = C.instance_id
4765: AND C.inventory_item_id = M.inventory_item_id
4766: AND C.inv_master_organization_id = M.organization_id

Line 5343: l_instance_number csi_item_instances.instance_number%TYPE := upper(nvl(p_instance_number, '%'));

5339: -- Please refer earlier version for the details
5340:
5341: l_instance_id NUMBER;
5342: l_inventory_item_id NUMBER;
5343: l_instance_number csi_item_instances.instance_number%TYPE := upper(nvl(p_instance_number, '%'));
5344: l_inventory_org_id NUMBER;
5345: l_quantity NUMBER;
5346: l_inventory_revision VARCHAR2(3);
5347: l_uom_code VARCHAR2(3);

Line 5351: l_serial_number csi_item_instances.serial_number%TYPE := upper(nvl(p_serial_number, '%'));

5347: l_uom_code VARCHAR2(3);
5348: l_item_assoc_id NUMBER;
5349: l_priority NUMBER;
5350: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE :=upper(nvl(p_item_number, '%'));
5351: l_serial_number csi_item_instances.serial_number%TYPE := upper(nvl(p_serial_number, '%'));
5352: l_uc_header_id NUMBER;
5353: i NUMBER;
5354: j NUMBER;
5355: l_dummy_char VARCHAR2(1);

Line 5391: FROM csi_item_instances C,

5387: C.quantity,
5388: C.inventory_revision,
5389: C.unit_of_measure uom_code,
5390: to_number(NULL) uc_header_id
5391: FROM csi_item_instances C,
5392: mtl_system_items_kfv M,
5393: ahl_mc_relationships R,
5394: ahl_item_associations_b A
5395: WHERE C.inventory_item_id = M.inventory_item_id

Line 5507: csi_item_instances C,

5503: CR.relationship_type_code (+) = 'COMPONENT-OF' AND
5504: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
5505: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)
5506: ) U,
5507: csi_item_instances C,
5508: mtl_system_items_kfv M
5509: WHERE U.csi_instance_id = C.instance_id
5510: AND C.inventory_item_id = M.inventory_item_id
5511: AND C.inv_master_organization_id = M.organization_id

Line 6086: -- This API is used to create a new instance in csi_item_instances and assign it

6082: END get_available_instances;
6083:
6084: -- SATHAPLI::FP ER 6504147, 18-Nov-2008
6085: -- Define procedure create_unassigned_instance.
6086: -- This API is used to create a new instance in csi_item_instances and assign it
6087: -- to the UC root node as extra node.
6088:
6089: PROCEDURE create_unassigned_instance(
6090: p_api_version IN NUMBER := 1.0,

Line 6119: FROM csi_item_instances csi, csi_i_parties p

6115: party_id,
6116: party_source_table,
6117: instance_party_id,
6118: csi.wip_job_id
6119: FROM csi_item_instances csi, csi_i_parties p
6120: WHERE csi.instance_id = p.instance_id
6121: AND p.relationship_type_code = 'OWNER'
6122: AND csi.instance_id = p_csi_instance_id
6123: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);