APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCES

Line 83: FROM csi_item_instances_h ciih,

79: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
80:
81: CURSOR pending_txn_cur(p_instance_id in number) is
82: SELECT ct.transaction_id
83: FROM csi_item_instances_h ciih,
84: csi_transactions ct
85: WHERE ciih.instance_id = p_instance_id
86: AND ct.transaction_id = ciih.transaction_id
87: AND ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119)

Line 128: FROM csi_item_instances

124: l_inventory_item_id,
125: l_organization_id,
126: l_inst_num,
127: l_serial_number
128: FROM csi_item_instances
129: WHERE instance_id = px_inst_asset_rec.instance_id;
130:
131: IF l_acct_class_code = 'CUST_PROD' THEN
132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');

Line 301: FROM csi_item_instances

297: quantity
298: INTO l_location_type_code,
299: l_location_id,
300: l_instance_quantity
301: FROM csi_item_instances
302: WHERE instance_id = p_instance_rec.instance_id;
303: ELSE
304: l_location_type_code := p_instance_rec.location_type_code;
305: l_location_id := p_instance_rec.location_id;