APPS.CSI_INV_TRXS_PKG dependencies on CSI_ITEM_INSTANCES

Line 109: FROM csi_item_instances

105: r_id c_id%rowtype;
106:
107: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
108: SELECT object_version_number
109: FROM csi_item_instances
110: WHERE instance_id = pc_instance_id;
111:
112: CURSOR c_phys_inv_info (pc_physical_adjustment_id IN NUMBER) is
113: SELECT mpi.physical_inventory_id physical_inventory_id,

Line 627: FROM csi_item_instances

623:
624: BEGIN
625: SELECT owner_party_id
626: INTO l_owner_party_id
627: FROM csi_item_instances
628: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
629:
630: EXCEPTION
631: WHEN no_data_found THEN

Line 720: FROM csi_item_instances

716:
717: BEGIN
718: SELECT owner_party_id
719: INTO l_owner_party_id
720: FROM csi_item_instances
721: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
722:
723: EXCEPTION
724: WHEN no_data_found THEN

Line 1265: FROM csi_item_instances

1261: r_id c_id%rowtype;
1262:
1263: CURSOR c_obj_version (pc_instance_id IN NUMBER) is
1264: SELECT object_version_number
1265: FROM csi_item_instances
1266: WHERE instance_id = pc_instance_id;
1267:
1268: BEGIN
1269: x_return_status := l_fnd_success;

Line 1720: FROM csi_item_instances

1716:
1717: BEGIN
1718: SELECT owner_party_id
1719: INTO l_owner_party_id
1720: FROM csi_item_instances
1721: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
1722:
1723: EXCEPTION
1724: WHEN no_data_found THEN

Line 1803: FROM csi_item_instances

1799:
1800: BEGIN
1801: SELECT owner_party_id
1802: INTO l_owner_party_id
1803: FROM csi_item_instances
1804: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
1805:
1806: EXCEPTION
1807: WHEN no_data_found THEN

Line 2524: SELECT 1 FROM csi_item_instances

2520: BEGIN
2521: SELECT 'Y' INTO l_return_item
2522: FROM sys.dual
2523: WHERE EXISTS (
2524: SELECT 1 FROM csi_item_instances
2525: WHERE serial_number = l_mtl_item_tbl(j).serial_number
2526: AND inventory_item_id = l_mtl_item_tbl(j).inventory_item_id
2527: AND (instance_usage_code = 'RETURNED'
2528: OR (instance_usage_code = 'IN_TRANSIT' AND active_end_date IS NOT NULL)));

Line 4702: ,csi_item_instances_h ciih

4698: /*CURSOR get_redeploy_flag_cur
4699: IS
4700: SELECT 'Y' redeploy_flag
4701: FROM csi_transactions ct
4702: ,csi_item_instances_h ciih
4703: ,csi_item_instances cii
4704: WHERE ct.transaction_id = ciih.transaction_id
4705: AND ciih.instance_id = cii.instance_id
4706: AND cii.inventory_item_id = p_inventory_item_id

Line 4703: ,csi_item_instances cii

4699: IS
4700: SELECT 'Y' redeploy_flag
4701: FROM csi_transactions ct
4702: ,csi_item_instances_h ciih
4703: ,csi_item_instances cii
4704: WHERE ct.transaction_id = ciih.transaction_id
4705: AND ciih.instance_id = cii.instance_id
4706: AND cii.inventory_item_id = p_inventory_item_id
4707: AND cii.serial_number = p_serial_number

Line 4716: FROM csi_item_instances cii

4712: CURSOR get_redeploy_flag_cur
4713: IS
4714: SELECT /*+ ordered */
4715: 'Y' redeploy_flag
4716: FROM csi_item_instances cii
4717: ,csi_item_instances_h ciih
4718: ,csi_transactions ct
4719: WHERE ct.transaction_id = ciih.transaction_id
4720: AND ciih.instance_id = cii.instance_id

Line 4717: ,csi_item_instances_h ciih

4713: IS
4714: SELECT /*+ ordered */
4715: 'Y' redeploy_flag
4716: FROM csi_item_instances cii
4717: ,csi_item_instances_h ciih
4718: ,csi_transactions ct
4719: WHERE ct.transaction_id = ciih.transaction_id
4720: AND ciih.instance_id = cii.instance_id
4721: AND cii.inventory_item_id = p_inventory_item_id

Line 5257: SELECT 1 FROM csi_item_instances

5253: BEGIN
5254: SELECT 'Y' INTO l_returned_item
5255: FROM sys.dual
5256: WHERE EXISTS (
5257: SELECT 1 FROM csi_item_instances
5258: WHERE serial_number = l_mtl_item_tbl(table_index).serial_number
5259: AND inventory_item_id = l_mtl_item_tbl(table_index).inventory_item_id
5260: AND (instance_usage_code = 'RETURNED'
5261: OR (instance_usage_code = 'IN_TRANSIT' AND active_end_date IS NOT NULL)));